Skip site navigation (1) Skip section navigation (2)

Re: pg_dump fails

From: david(at)netventures(dot)com(dot)au
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump fails
Date: 2001-09-27 23:07:37
Message-ID: Pine.LNX.4.21.0109280900230.12990-100000@netventures.com.au (view raw or flat)
Thread:
Lists: pgsql-admin
Answering my own question (With some advice from Tom Lane .. Cheers), 
I had 2 users with the same usesysid, and this broke the dump (The dump
that came with pgsql 7.1). 

It was easy to fix, I just needed to change the usesysid in pg_shadow of
the user that I didn't intend to have owndership of the db and tables (It
was actually a test user I had created for some reason).

It may be worth noting that this duplication of usesysid did not prevent
pg_dump from working in Postgres 7.0 (However, and this should have
alerted me) it was dupliucating the dump of each table for each user.

| Here goes:
| 
| $ sudo su - postgres
| $ pg_dump -x -Ft nvplayer > nvplayer-010920.tar
| getDatabase(): SELECT failed.  Explanation from backend: 'ERROR:  More
| than one tuple returned by a subselect used as an expression.
| '.
| 
| Any suggestions?

David Stanaway.


pgsql-admin by date

Next:From: Randall PerryDate: 2001-09-28 02:25:44
Subject: postmaster dies with ssl lib error
Previous:From: Herbert Rabago AmbosDate: 2001-09-27 22:11:37
Subject: Re: turning on debug without restarting postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group