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: | Raw Message | Whole Thread | 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 |