Re: FATAL 1: Relation 'pg_shadow' does not exist

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: FATAL 1: Relation 'pg_shadow' does not exist
Date: 2002-01-15 10:44:02
Message-ID: Pine.LNX.4.21.0201152141450.27547-100000@linuxworld.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 15 Jan 2002, Hiroshi Inoue wrote:

> > Does anyone have any ideas about this? Anything to prevent my needing to
> > go to tape and spend a long night in a cold cold server room?
>
> Can you connect to the db using standalone postgres ?
> i.e.
>
> postgres -P -O your_database_name

When I first brought it down, I attempted this, but forgot -O. I've just
done this, however, it connected fine. Moreover, a select * from
pg_shadow; returned results! I vacuumed and brought the database back
online -- everything fine.

Extremely strange =\.

Gavin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Luis Amigo 2002-01-15 11:18:57 Psql in cluster-machines
Previous Message Ryouichi Matsuda 2002-01-15 10:41:31 Re: Failure in timestamptz of JDBC of 7.2b4