Обсуждение: pg_dumpall and pg_restore issues

Поиск
Список
Период
Сортировка

pg_dumpall and pg_restore issues

От
Darren McClelland
Дата:
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

Re: pg_dumpall and pg_restore issues

От
Bruce Momjian
Дата:
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@postgresql.org)
>

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

Re: pg_dumpall and pg_restore issues

От
Bruce Momjian
Дата:
I did some research and I see this in the pg_dumpall that will be
distributed in 7.3:

        -F*|--format=*|-f|--file=*|-t|--table=*)
                echo "pg_dump can not process option $1, exiting" 1>&2
                exit 1
                ;;

Seems I actually did the work:

    revision 1.17
    date: 2002/04/11 04:56:21;  author: momjian;  state: Exp;  lines: +14 -11
    Fix problem with invalid database name assignment in while loop.
    Properly warn of invalid pg_dumpall options;  minor quoting cleanups.

Anyway, it will properly warn you in 7.3.

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

Bruce Momjian wrote:
>
> 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@postgresql.org)
> >
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

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