Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Postgres backup error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Postgres backup error" Watch "Postgres backup error" New topic
Author

Postgres backup error

Kaywin Dcosta
Greenhorn

Joined: Jan 19, 2008
Posts: 4
Hi!

I have a postgresql 7.4.2. When i try to use pg_dump i
get the next error:

pg_dump: saving encoding
pg_dump: saving database definition
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 = 'db'


How can i take the backup.
 
GeeCON Prague 2014
 
subject: Postgres backup error