problems with pg_dump

From: David Suela Fernández <dsuela(at)xsto(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: problems with pg_dump
Date: 2004-08-24 09:34:30
Message-ID: 1093340070.18467.4.camel@yen-lo-wang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I have a debian woody with 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'
pg_dump: *** aborted because of error

I want to do a daily backup, otherway to do this without pg_dump?

Thanks,

Suela.

Browse pgsql-general by date

  From Date Subject
Next Message Silvio Matthes 2004-08-24 09:59:45 select ... where <column>='' does a seqscan [auf Viren geprueft]
Previous Message Michael Seele 2004-08-24 09:28:24 replace array values in a select statement