[CentOS] relation "pg_user" does not exist error when runningpg_dump

Thu Apr 28 19:46:56 UTC 2005
Marc Powell <marc at ena.com>


> -----Original Message-----
> From: centos-bounces at centos.org [mailto:centos-bounces at centos.org] On
> Behalf Of Andy Masiar
> Sent: Thursday, April 28, 2005 2:41 PM
> To: centos at centos.org
> Subject: [CentOS] relation "pg_user" does not exist error when
> runningpg_dump
> 
> Hi,
> 
> I'm trying to move a postgres database to another server and I ran
> into some weird problems. Pg_dump command was not giving any output
> and the logs got filled with some SELinux errors. So I turned off
> SELinux completely (and rebooted). Now I'm getting the following error
> message:
> 
> # pg_dump -U postgres database > database.out
> 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 = 'database'

Googling for the error message (*hint hint*) indicates this is most
often caused by a version mismatch between your pg_dump, psql, etc, and
the actual postgres database you are connecting to. Is that the case?

--
Marc