On Thu, Mar 4, 2010 at 9:00 PM, Fujii Masao masao.fu...@gmail.com wrote:
And, when we start an archive recovery from the backup from the standby,
we seem to reach a safe starting point before database has actually become
consistent. It's because backupStartLoc is zero. Isn't this an issue?
Hi,
I thought of this issue again since the related question arrived.
http://archives.postgresql.org/pgsql-admin/2010-03/msg00036.php
On Thu, Jan 14, 2010 at 7:13 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Wed, Jan 13, 2010 at 9:34 PM, Heikki Linnakangas
Our documentation suggests that you can take a base backup of a warm
standby server while it's running:
If we take a backup of the standby server's data directory while it is
processing logs shipped from the primary, we will be able to reload that data
and restart the standby's recovery
On Wed, Jan 13, 2010 at 8:36 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Our documentation suggests that you can take a base backup of a warm
standby server while it's running:
If we take a backup of the standby server's data directory while it is
processing logs
Fujii Masao wrote:
On Wed, Jan 13, 2010 at 8:36 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
I wonder if it would be enough to document that pg_control must be
backed up first?
Probably No. The archive recovery from such base backup would always
fail at the end of
On Wed, Jan 13, 2010 at 9:34 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
No, that's not an issue. We only wait for the backup-end record if we
haven't seen yet since we started recovery from the base backup.
Assuming the standby had reached that point already before the