Re: pg_dumpall and output formats?

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