Axel -
Look in the Postgresql source area and/or perhaps your distribution for this:
files/502.pgsql
It is a shell script that does a live dump of your database to files which can
then be backed up. Backing up Postgresql directly will be of no use as you
already know. Just fire it off a few minutes right before Amanda is set to
start -- though you should figure out how long it takes to run and gauge it
from there.
I'm surprised the Amanda site doesn't have an FAQ on this since this seems to
come up fairly often (I just checked but didn't find it).
-doug
On Tuesday 29 July 2003 11:54 am, 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!
|
