Re: [CentOS] relation "pg_user" does not exist error when running pg_dump

Am Do, den 28.04.2005 schrieb Andy Masiar um 21:40:

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

Andy

Above error is a result of a bug SELinux <--> PostgreSQL. There is a bugzilla and in it's comments a way how to initialize PostgreSQL correctly. I had the same issue with a fresh new CentOS 4 install.

Alexander