Обсуждение: pg_dumpall which also dumps lo

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

pg_dumpall which also dumps lo

От
Martijn de Munnik
Дата:
I modified the pg_dumpall script to pg_dumpalltodir script. This script
dumps all databases to a dir (specified with the -e or --dir switch)
including the large objects. But i'm not sure if it's correct and it dumps
all info to rebuild the whole database system after a fatal crash...

with kindly regards,

Martijn de Munnik

De Munnik Services
Julianastraat 21
5151 VT Drunen
W http://www.demunnikservices.nl
E info@demunnikservices.nl
T (0416) 374586
F (0416) 320015

Вложения

Re: pg_dumpall which also dumps lo

От
Bruce Momjian
Дата:
Is this based on 7.0.X or 7.1.X?  I thought we had this capability in
7.1.X.


> I modified the pg_dumpall script to pg_dumpalltodir script. This script
> dumps all databases to a dir (specified with the -e or --dir switch)
> including the large objects. But i'm not sure if it's correct and it dumps
> all info to rebuild the whole database system after a fatal crash...
>
> with kindly regards,
>
> Martijn de Munnik
>
> De Munnik Services
> Julianastraat 21
> 5151 VT Drunen
> W http://www.demunnikservices.nl
> E info@demunnikservices.nl
> T (0416) 374586
> F (0416) 320015

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026