Re: pg_dumpall and output formats? - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: pg_dumpall and output formats?
Date
Msg-id 200208200220.g7K2KnJ17299@candle.pha.pa.us
Whole thread Raw
In response to Re: pg_dumpall and output formats?  ("John Madden" <jmadden@ivytech.edu>)
List pgsql-admin
John Madden wrote:
> > *pg_dumpall* doesn't support large objects
> >
> > pg_dumpall [-c | --clean] [-g | --globals-only] [-h host] [-p port] [-U
> > username] [-W]
>
> Ah, but aren't "all other options" supposed to be passed to pg_dump?
> That's what I absorbed from the docs.
>
> > You'll need to dump that db explicitly with pg_dump.
>
> Righto.  I don't actually *use* large objects atm, but I'm writing a
> backup script that I'd like to have support future DB's that might.

7.3 will properly throw an error if you try to use -F with pg_dumpall.
The 7.2 documentation mentions -f and -t as not supported but doesn't
mention -F.  7.3 will mention that too.

--
  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

pgsql-admin by date:

Previous
From: "John Madden"
Date:
Subject: Re: pg_dumpall and output formats?
Next
From: "Darrin Domoney"
Date:
Subject: Event recurrence - in database or in application code ????