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
Am Fr, den 29.04.2005 schrieb Alexander Dalloz um 2:37:
# 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
To complete my reply: the bugzilla ticket and the comment which I followed to successfully initiate the PostgreSQL server:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=152591#c1
Alexander
Thank you for your replies.
First of all, this is not a new centos install, it has been running quite reliably for some time until now. All posgresql packages are stock centos and SELinux is disabled.
Also, my application is working fine, I can run queries against the database. I get the error only when I'm trying to perform a backup to move the data to another server. I can't init the db, I would lose my data. I have backups from about 2 weeks ago but it would suck to have to revert to them :-(
Andy
On 4/28/05, Alexander Dalloz ad+lists@uni-x.org wrote:
Am Fr, den 29.04.2005 schrieb Alexander Dalloz um 2:37:
# 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
To complete my reply: the bugzilla ticket and the comment which I followed to successfully initiate the PostgreSQL server:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=152591#c1
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 03:44:44 up 17 days, 25 users, load average: 0.16, 0.31, 0.37
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-
Alexander Dalloz -
Andy Masiar