Skip site navigation (1) Skip section navigation (2)

Re: Recovery bug

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Recovery bug
Date: 2010-10-19 20:55:13
Message-ID: AANLkTi=+id-5dezP56KS4wRufoULxKA7XpCBmnNaWerH@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, Oct 19, 2010 at 5:26 AM, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> The fundamental problem is that by definition, a base backup is completely
> indistinguishable from the data directory in the original server. Or is it?
> We recommend that you exclude the files under pg_xlog from the backup. So we
> could create a "pg_xlog/just_kidding" file along with backup_label. When
> starting recovery, if just_kidding exists, we can assume that we're doing
> crash recovery and ignore backup_label.

I think you'll find that it's completely impossible to make this work
reliably given all of the ways people may choose to make a backup.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

pgsql-bugs by date

Next:From: Robert HaasDate: 2010-10-19 20:57:05
Subject: Re: BUG #5705: btree_gist: Index on inet changes query result
Previous:From: Jeff DavisDate: 2010-10-19 19:40:14
Subject: Re: Recovery bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group