relation "pg_user" does not exist error when running pg_dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux