| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Brian Avis <brian(dot)avis(at)searhc(dot)org> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Backups and restores. |
| Date: | 2003-06-10 15:08:10 |
| Message-ID: | Pine.LNX.4.33.0306100907300.13190-100000@css120.ihs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 6 Jun 2003, Brian Avis wrote:
>
> 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
>
> Which generates this sort of file.
>
> pgdump_2003-6-5-csp.gz
> When I try to use pg_restore from 7.3.3 to restore that file with this
> command.
> ./bin/pg_restore -d csp pgdump_2003-6-5-csp
> Or even this one.
> ./bin/pg_restore -d csp pgdump_2003-6-5-csp.gz
>
> I get this error.
>
> pg_restore: [archiver] input file does not appear to be a valid archive
Are you un gzipping the file before feeding it to pg_restore?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Colombo | 2003-06-10 15:09:12 | Re: update phenomenon |
| Previous Message | scott.marlowe | 2003-06-10 15:00:07 | Re: [HACKERS] SAP and MySQL ... [and Benchmark] |