Re: pg_dumpall and output formats?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_dumpall and output formats?
Дата
Msg-id 200208200220.g7K2KnJ17299@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: pg_dumpall and output formats?  ("John Madden" <jmadden@ivytech.edu>)
Список 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 по дате отправления:

Предыдущее
От: "John Madden"
Дата:
Сообщение: Re: pg_dumpall and output formats?
Следующее
От: "Darrin Domoney"
Дата:
Сообщение: Event recurrence - in database or in application code ????