Re: Recovery bug

On Tue, Oct 19, 2010 at 5:26 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.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