Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group