Re: Full backup - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Full backup
Date
Msg-id Pine.LNX.4.30.0106202231430.725-100000@peter.localdomain
Whole thread Raw
In response to Full backup  (Felipe Carasso <hrimhari@tecgraf.puc-rio.br>)
List pgsql-admin
Felipe Carasso writes:

>     It would be very nice, in my opinion, if the pg_dumpall tool could
> include all system tables in the dump, possibly checking for superuser
> access before doing that. It seems that only pg_shadow is added.

There is hardly ever a reason to save the full content of the system
catalogs, because the "standard" content would be added back by initdb and
the local modifications are saved by pg_dump in the form of CREATE
SOMETHING commands.  At least that *should* be the case.  Is there a
particular case you are having trouble with?

>     Also, it seems that pg_dumpall is unable to pass the -F flag to
> the sucessive calls to pg_dump.

That would be nice, but it's tricky to work out how to make sure you can
restore everything in one piece.  As it is, you could have a piece of text
file from pg_dumpall proper and a bunch of compressed archives or some
such created by the pg_dumps.  Maybe pg_dumpall needs to be taught about
the several formats that pg_dump now offers.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Re: pg_dump dumps views as tables???
Next
From: Rangachari Anand
Date:
Subject: High CPU utilization by postmaster