Andy Masiar
2005-Apr-28 19:40 UTC
[CentOS] 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
Alexander Dalloz
2005-Apr-29 00:37 UTC
[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> AndyAbove 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>