Re: Relation 'pg_user' does not exist - Mailing list pgsql-general

From Matt Beauregard
Subject Re: Relation 'pg_user' does not exist
Date
Msg-id 20001109101920.R324@designscape.com.au
Whole thread Raw
In response to Re: Relation 'pg_user' does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Relation 'pg_user' does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Nov 08, 2000 at 12:57:50AM -0500, Tom Lane wrote:
> Matt Beauregard <matt@designscape.com.au> writes:
> > I get the following error trying to make my backups:
> > !2188 marauder@bofh:~$ pg_dump -h tweedledee -D ds >ds_1108.sql
> > getTypes(): SELECT failed.  Explanation from backend: 'ERROR:
> > Relation 'pg_user' does not exist
>
> Hmm, did you do something silly like delete pg_user?

No... I have no idea where the table went.  Which database do I need
to connect to in order to recreate it?  I tried recreating it in
template1 and got a set of interesting errors about also missing
pg_views.


--
Matt Beauregard
Information Technology Operations, DesignScape

Ph: +61 2 9361 4233   Fx: +61 2 9361 4633

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Built-in Postgres Types as shown in Chap. 4 Programmer's Guide
Next
From: Tom Lane
Date:
Subject: Re: Relation 'pg_user' does not exist