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

Hi all
    when I connected a database, it display the error message "ERROR:  Relation "pg_user" does not exist".

    How to solve the issue?

    Thanks & Best Regards

    Derek

Qiao Jian ( Net2Room) wrote:
> Hi all
>     when I connected a database, it display the error message "ERROR:
> Relation "pg_user" does not exist".
>
>     How to solve the issue?

Hi Derek,

It'd be helpful to know a bit more info so we can assist:

  + Which version of PostgreSQL is running (if known)?
  + Which operating system is PostgreSQL running on?
  + What is the program that you're using to connect to PostgreSQL?
  + What is the name of the user that you're trying to connect to
PostgreSQL as?

This should really help us figure things out.

:-)

Regards and best wishes,

Justin clift


>     Thanks & 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

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
   

-----Original Message-----
From: Justin Clift [mailto:justin@postgresql.org]
Sent: 2003年1月22日 12:20
To: Qiao Jian ( Net2Room)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] FW: ERROR: Relation "pg_user" does not exist

Qiao Jian ( Net2Room) wrote:
> Hi all
>     when I connected a database, it display the error message "ERROR:
> Relation "pg_user" does not exist".
>
>     How to solve the issue?

Hi Derek,

It'd be helpful to know a bit more info so we can assist:

  + Which version of PostgreSQL is running (if known)?
  + Which operating system is PostgreSQL running on?
  + What is the program that you're using to connect to PostgreSQL?
  + What is the name of the user that you're trying to connect to
PostgreSQL as?

This should really help us figure things out.

:-)

Regards and best wishes,

Justin clift

>     Thanks & 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

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