| From: | Darren McClelland <darren(at)zonarsystems(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_dumpall and pg_restore issues |
| Date: | 2002-08-14 01:07:56 |
| Message-ID: | 20020814010753.9591B4754A0@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
I'm having problems using pg_dumpall and pg_restore together.
Basically I can't get pg_restore to recognise the dump as a valid archive.
Example:
Create a dump like this pg_dumpall -U postgres -Fc -Z 9 > /tmp/dump
Then try to restore it
$
pg_restore -U postgres -Fc /tmp/dump
pg_restore: [archiver] did not find magic string in file header
or
$pg_restore -U postgres /tmp/dump
pg_restore: [archiver] input file does not appear to be a valid archive
The dump file is strange too, it starts out as a standard SQL dump like
pg_dump produces, then shifts to binary, Iassume thats the compressed data.
The same pattern contnues throughout the file, straight SQL text then big
chunks of binary data.
Version:
$pg_dumpall --version
pg_dumpall (PostgreSQL) 7.2.1
Does anyone have any ideas?
Thanks,
Darren McClelland
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-08-14 01:21:04 | Re: pg_dumpall and pg_restore issues |
| Previous Message | Tim Ellis | 2002-08-14 00:09:18 | tedia2sql 1.2.4 released |