Re: PITR Base Backup on an idle 8.1 server

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Marco Colombo" <pgsql(at)esiway(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: PITR Base Backup on an idle 8.1 server
Date: 2007-06-05 16:49:03
Message-ID: 1181062144.20397.49.camel@silverbirch.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-06-05 16:52:02 Re: Corruption of files in PostgreSQL
Previous Message Marco Colombo 2007-06-05 16:39:52 Re: PITR Base Backup on an idle 8.1 server