Re: how do you run your backups?

From: "Vadim Mikheev" <vmikheev(at)sectorbase(dot)com>
To: "David Wall" <d(dot)wall(at)computer(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: how do you run your backups?
Date: 2001-01-27 05:29:50
Message-ID: 005d01c08822$2c4d4160$4779583f@sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2001-01-27 06:25:42 Re: Re: MySQL has transactions
Previous Message Bruce Momjian 2001-01-27 05:01:09 Re: high level specs on PL ?