Re: Error Message Using pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Richards <drichard(at)largo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Error Message Using pg_dumpall
Date: 2003-07-20 04:59:47
Message-ID: 20042.1058677187@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

David Richards <drichard(at)largo(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ken Godee 2003-07-20 05:13:08 Re: Help with privilege or pg_hba.conf
Previous Message Tom Lane 2003-07-20 04:52:01 Re: initdb fails after installation on Mac OS X 10.2.6

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-20 05:04:25 Re: Problem with a constraint check on a table.
Previous Message Tom Lane 2003-07-20 03:56:20 Re: Urgent: 10K or more connections