Re: Database Backup

Hi,
for dumping postgres-databases to flat files postgres has two utilities:

pg_dump for a single database and pg_dumpall for all databases on asingle server.these commands produce a flat text file containing sql-querrys torecreate the complete database(s).

Doing the dump of the life DBMS isn't a good idea. You don't catch allthe changes and informations that postgres keeps in it's internalbuffer's at runtime.


Christoph


Brian Cuttler wrote:

Axel,

I'm so sorry, this is pretty much a database question and as such
out of my area of expertise.

There is no way to shutdown the application for the duration ?
That is what I've forced my Oracle dba to do.

-- Start of PGP signed section.

Hi Brian,
I have amanda running on two fileservers already. The box in question
now is RedHat Linux 9.0 running a Postgresqul database. The Tapedrive is

a DDS4 manual.I am asking this question because I know of no way to export the

database into a flat file before backup, or mirroring or freezing the
database during backup.
I was wondering if somebody did that before.
cheers
Axel

On Tue, 2003-07-29 at 14:37, Brian Cuttler wrote:

Axel,

Amanda is a scheduler, optionally compressing data but uses
OS native backup services, either the native form of dump
(ufsdump, xfsdump...) or most often some brand of "tar", what
OS are you running, what tools are available for backup and
what do Postgresql knowledgable people say about tools for
backing up the database ?

Can I backup a life Postgresql Database with Amanda?


--
Axel Haenssen
Department of Ecology and Evolutionary Biology
Princeton University
Princeton, NJ 08544-1003
phone: +1(609)258-6999
Find my Public Key here:
http://www.princeton.edu/~axel


-- End of PGP section, PGP failed!