pg_restore problem
Started by Nonamealmost 22 years ago2 messagesgeneral
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
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.