Full backup

From: Felipe Carasso <hrimhari(at)tecgraf(dot)puc-rio(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Full backup
Date: 2001-06-16 17:35:47
Message-ID: 200106161735.OAA29083@magritte.tecgraf.puc-rio.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello :)

It is important to me to be able to have a full backup of
everything needed by PostgreSQL in case of data loss. Things like hardware
problems or accidental erasure should be kept in mind.

In order to do this, I've been doing a .tar.gz for the entire
pgsql home, and that has many drawbacks as you all probably know.

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.

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

I apologise if this topic has already been raised.

[]'s HHHHHHH . HHHHHHHHHHHHH //
HHHHHHH .|i HHHHRIMHARIHH ,':
F e l i p e HHHH --+~ ``\ HHHHHHHHHHHH ; :
HH _`; ``\_ HHHHHHHHH ; ;
(H r i m h a r i) HHH`' `~'`. ````---..___. ,';
HHHHHHHHHH \ \//'
C a r a s s o HHHHHHHHHHH `| \
HHHHHHHHHHH , \-\______ /~| ;
HHHHHHHHHH ;:\ :` HHH / / ; :`
HHHHHHHHH ;:` ;: HHHH |_ \ -\\
hrimhari(at)rdc(dot)puc-rio(dot)br HHHHHH +/, _;:` HHHH _// //
wwwusers.rdc.puc-rio.br/hrimhari/ HHHH ' ` ~ ` HHHH ~ ` ~^-
/"\
\ / Campanha da fita ASCII - contra mail html e reply nao editado
X ASCII ribbon campaign - against html mail and non-edited reply
/ \

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Brian McCane 2001-06-16 20:51:29 Re: performance issues
Previous Message Lamar Owen 2001-06-15 20:47:41 Re: SRPMS