On Wed, 2004-08-25 at 15:08, David Suela Fernández wrote: > The problem is that pg_dump always give me the next error: > > 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 = 'ez3'
Maybe recreating pg_user in the database will help. It is a global table, so if you have other databases where pg_user exists, copy the row from pg_class in that database to pg_class in the corrupted database. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== "But the day of the Lord will come as a thief in the night. The heavens shall pass away with a great noise, and the elements shall melt with fervent heat, and the earth and the works that are therein shall be burned up." II Peter 3:10 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend