Re: PITR Base Backup on an idle 8.1 server - Mailing list pgsql-general

From Simon Riggs
Subject Re: PITR Base Backup on an idle 8.1 server
Date
Msg-id 1181062144.20397.49.camel@silverbirch.site
Whole thread Raw
In response to Re: PITR Base Backup on an idle 8.1 server  (Marco Colombo <pgsql@esiway.net>)
Responses Re: PITR Base Backup on an idle 8.1 server  (Marco Colombo <pgsql@esiway.net>)
List pgsql-general
On Tue, 2007-06-05 at 18:39 +0200, Marco Colombo wrote:
> I'm asking: what _exactly_ can go wrong?

If a checkpoint occurs while taking the backup then the contents of the
files will be overwritten and you will be unable to rollforward from
before the backup until after the backup. This will give you the FATAL
error message "WAL ends before end time of backup dump". You won't know
this until you have attempted recovery using those files, even if the
scripts give rc=0.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



pgsql-general by date:

Previous
From: Marco Colombo
Date:
Subject: Re: PITR Base Backup on an idle 8.1 server
Next
From: Scott Marlowe
Date:
Subject: Re: Corruption of files in PostgreSQL