Re: Allowing multiple concurrent base backups - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Allowing multiple concurrent base backups
Date
Msg-id 1294788218.26320.12.camel@jdavis-ux.asterdata.local
Whole thread Raw
In response to Re: Allowing multiple concurrent base backups  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On Tue, 2011-01-11 at 23:07 +0100, Magnus Hagander wrote: 
> I think keeping the flexibility is important. If it does add an extra
> step I think that's ok once we have pg_basebackup, but it must be
> reasonably *safe*. Corrupt backups from forgetting to exclude a file
> seems not so.

Agreed.

> But if the problem is you forgot to exclude it, can't you just remove
> it at a later time?

If you think you are recovering the primary, and it's really the backup,
then you get corruption. It's too late to remove a file after that
(unless you have a backup of your backup ;) ).

If you think you are restoring a backup, and it's really a primary that
crashed, then you run into one of the two problems that I mentioned
(which are less severe than corruption, but very annoying).

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: arrays as pl/perl input arguments [PATCH]
Next
From: "Kevin Grittner"
Date:
Subject: SSI patch version 10