Re: FW: ERROR: Relation "pg_user" does not exist

From: Justin Clift <justin(at)postgresql(dot)org>
To: "Qiao Jian ( Net2Room)" <qiaoj(at)net2room(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FW: ERROR: Relation "pg_user" does not exist
Date: 2003-01-22 08:21:54
Message-ID: 3E2E54A2.7010802@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Derek,

Oh, that's definitely not good.

It sounds like some kind of corruption has occured to your database, or
that someone has deleted (maybe accidentally) the pg_users table.

Is there any chance that your server (or even just PostgreSQL) has
crashed since the last time you used psql?

Regards and best wishes,

Justin Clift

Qiao Jian ( Net2Room) wrote:
> Hi Justin
> I use postgresql 7.2.1 on Redhat 7.3.
>
> I use psql on terminal for connecting a database, such as #psql
> database_name.
>
> formerly it is ok, but today it display the error, I don't know what
> happen.
>
> Best Regards
>
> Derek

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chantal Ackermann 2003-01-22 10:30:32 optimizing query
Previous Message Lincoln Yeoh 2003-01-22 07:07:57 Re: postmaster.pid