Re: pg_restore problem

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: mail(at)ekaiser(dot)de, postgres-Liste <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore problem
Date: 2004-04-27 16:46:02
Message-ID: 200404271846.02385.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mail(at)ekaiser(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2004-04-27 16:57:33 Re: shadowing (like IB/Firebird)
Previous Message Peter Eisentraut 2004-04-27 16:44:03 Re: Unicode encoding