X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 210AA9FB278 for ; Wed, 12 Jul 2006 09:48:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 23416-09 for ; Wed, 12 Jul 2006 09:48:30 -0300 (ADT) X-Greylist: delayed 00:06:39.601345 by SQLgrey- Received: from web8809.mail.in.yahoo.com (web8809.mail.in.yahoo.com [203.84.221.18]) by postgresql.org (Postfix) with SMTP id 664F19FB215 for ; Wed, 12 Jul 2006 09:48:30 -0300 (ADT) Received: (qmail 19368 invoked by uid 60001); 12 Jul 2006 12:41:46 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ODH0UF94EKuYCOv2G2DBbChwCD5hYX0aFyt4W0ZzL2IHUC97S4qxjtJ75PXbdiSW3giHq+phs/d/i8aSlVsELBbuK3AUgAjnAbHGmUWr/pzvYT+3stj4GeudfO1JhMuKuO/JtaXJHKh1z4+qtPYd3bNLxBqbswuc01Adl+tB8sQ= ; Message-ID: <20060712124146.19366.qmail@web8809.mail.in.yahoo.com> Received: from [203.200.31.62] by web8809.mail.in.yahoo.com via HTTP; Wed, 12 Jul 2006 13:41:46 BST Date: Wed, 12 Jul 2006 13:41:46 +0100 (BST) From: Adarsh T Subject: ERROR: relation "pg_user" does not exist To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-458312068-1152708106=:18321" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/129 X-Sequence-Number: 22375 --0-458312068-1152708106=:18321 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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: 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' 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. --0-458312068-1152708106=:18321 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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. --0-458312068-1152708106=:18321--