| From: | <btober(at)seaworthysys(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Cc: | <brian(dot)avis(at)searhc(dot)org> |
| Subject: | Re: Backups and restores. |
| Date: | 2003-06-09 12:18:03 |
| Message-ID: | 64983.216.238.112.88.1055161083.squirrel@$HOSTNAME |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Brian Avis writes:
>
>> I am upgrading my workstation to 7.3.3. I have some database
>> backups that were created with this command.
>>
>> /usr/local/pgsql/bin/pg_dump $db | gzip >
>> /usr/local/pgsql/backups/$filename
>
>> pg_restore: [archiver] input file does not appear to be a valid
>> archive
>
> These archives are supposed to be restored using psql. The pg_dump
> reference page should tell you the details.
>
Gee, the man page of pg_restore says:
DESCRIPTION
pg_restore is a utility for restoring a PostgreSQL
database from an archive created by pg_dump(1) in one of
the NON-PLAIN-TEXT (emphasis added) formats.
;)
~Berend Tober
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kallol Nandi | 2003-06-09 12:55:09 | DBCS |
| Previous Message | Ruben | 2003-06-09 09:39:10 | Re: Postmaster only takes 4-5% CPU |