CentOS - Apr 2005 - relation "pg_user" does not exist error when running pg_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'

Thank you for your help!

Andy

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


-- 
Alexander Dalloz | Enger, Germany | GPG http://pgp.mit.edu 0xB366A773
legal statement: http://www.uni-x.org/legal.html
Fedora Core 2 GNU/Linux on Athlon with kernel 2.6.11-1.14_FC2smp 
Serendipity 02:35:38 up 16 days, 23:16, load average: 0.21, 0.24, 0.21 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
URL:
<http://lists.centos.org/pipermail/centos/attachments/20050429/9d6c6a38/attachment-0001.sig>