Re: how do you run your backups? - Mailing list pgsql-general

From Vadim Mikheev
Subject Re: how do you run your backups?
Date
Msg-id 005d01c08822$2c4d4160$4779583f@sectorbase.com
Whole thread Raw
In response to how do you run your backups?  (adb <adb@Beast.COM>)
List pgsql-general
> > Is there a way to start with yesterday's dump and load each transaction
> > log dump in order until you have a complete restore of the database?

WAL based BAR is not implemented in 7.1
Try to use Rserv from 7.1' contrib - it generates consistent incremental
snapshots.

> Also, does a pg_dump guarantee a consistent view of all of the tables in a
 > database at a given snapshot in time, ...

Yes. And I believe it's reflected in docs.

Vadim



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: high level specs on PL ?
Next
From: Tom Lane
Date:
Subject: Re: Trouble porting postgreSQL to WinNT