ERROR: relation "pg_user" does not exist

From: Adarsh T <adarsh_day(at)yahoo(dot)co(dot)in>
To: pgsql-admin(at)postgresql(dot)org
Subject: ERROR: relation "pg_user" does not exist
Date: 2006-07-12 12:41:46
Message-ID: 20060712124146.19366.qmail@web8809.mail.in.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am running Postgresql 7.4.7-2PGDG on RHEL4 AS U1 on Proliant DL-360 system.

I am having problems with the pg_dump command.

The error was visible on execution of the command: <error-message> pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: relation "pg_user" does not exist pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, datpath FROM pg_database WHERE datname = 'mydatabase'
</error-message>

Whats the reason for the error ?

Please let me know.

Thanks in advance

Adarsh


---------------------------------
Find out what India is talking about on Yahoo! Answers India.
So, what’s NEW about the NEW Yahoo! Messenger? Find out.

Browse pgsql-admin by date

  From Date Subject
Next Message hector ramiro garcia cantu 2006-07-12 14:15:48 unsubscribe pgsql-admin
Previous Message Umamaheswaran Srinivasan 2006-07-12 10:30:58 required Disk Space