Re: Relation 'pg_user' does not exist

From: Matt Beauregard <matt(at)designscape(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Relation 'pg_user' does not exist
Date: 2000-11-08 23:19:20
Message-ID: 20001109101920.R324@designscape.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 08, 2000 at 12:57:50AM -0500, Tom Lane wrote:
> Matt Beauregard <matt(at)designscape(dot)com(dot)au> writes:
> > I get the following error trying to make my backups:
> > !2188 marauder(at)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ferruccio Zamuner 2000-11-08 23:43:14 Re: permissions on databases vs. permissions on tables
Previous Message Peter Eisentraut 2000-11-08 22:50:55 Re: Built-in Postgres Types as shown in Chap. 4 Programmer's Guide