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