Error Message Using pg_dumpall

Started by David Richardsover 22 years ago2 messagesgeneral
Jump to latest
#1David Richards
drichard@largo.com

I'm not on these lists, please reply to me directly if you have any
information:

We are attempting to upgrade from version 7.1 to 7.2 of Postgres. Part
of the upgrade is to perform a pg_dumpall and dump the data, and then
reload it back into 7.2. When I issue the command, I get the following
error. Searches have yielded me nothing, and I'm wondering if anyone
has a clue as to what is causing this.

Thanks in advance.

------(snip)------------------------

new_largo:/var/lib/pgsql >pg_dumpall > /home/largo/dkr.dump
ERROR: Relation 'pg_user' does not exist
getDatabase(): SELECT failed. Explanation from backend: 'ERROR:
Relation 'pg_u
ser' does not exist
'.
----(snip)------------------------------

Dave Richards
Systems Administrator
City of Largo, Florida
drichard@largo.com

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: David Richards (#1)
Re: Error Message Using pg_dumpall

David Richards <drichard@largo.com> writes:

new_largo:/var/lib/pgsql >pg_dumpall > /home/largo/dkr.dump
ERROR: Relation 'pg_user' does not exist
getDatabase(): SELECT failed. Explanation from backend: 'ERROR:
Relation 'pg_user' does not exist

pg_dump does expect the pg_user view to be there ... have you dropped
it for some reason?

regards, tom lane