pg_restore problem

От:

mail@ekaiser.de

Дата:

26 апреля 2004 г. в 15:53:52

Hi,

from 7.3 I created a backup by:

pg_dumpall > backup

from 7.4 trying: pg_restore backup

results in postgres' [Archiver]s suspicion that "backup"
was not a valid archive.

Where to look?

TIA Erwin

Re: pg_restore problem

От:

Peter Eisentraut <peter_e@gmx.net>

Дата:

27 апреля 2004 г. в 13:46:07

mail@ekaiser.de wrote:
> pg_dumpall > backup
> from 7.4 trying: pg_restore backup
> results in postgres' [Archiver]s suspicion that "backup"
> was not a valid archive.

What you backup by pg_dumpall is to be restored using psql, not 
pg_restore.  Read the man pages of pg_dump and pg_dumpall to confirm 
what is to be used to restore the various forms of backups.