Re: pg_dumpall and pg_restore issues

Yes, pg_dumpall doesn't recognize the -F flags. It only dumps as text
format.

The manual page says:

Any other command line parameters are passed to the underlying
<xref linkend="app-pgdump">
calls. This is useful to control some aspects of the output
format, but some options such as <option>-f</option>,
<option>-t</option>, and <replaceable
class="parameter">dbname</replaceable> should be avoided.

We should throw an error if -f or -F is passed to pg_dumpall. I will
add some code to try and catch that for 7.3.

---------------------------------------------------------------------------

Darren McClelland wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073