Re: [HACKERS] Incrementally Updated Backups and restartpoints

2010-03-26 Thread Fujii Masao
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?

Re: [HACKERS] Incrementally Updated Backups and restartpoints

2010-03-04 Thread Fujii Masao
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

Re: [HACKERS] Incrementally Updated Backups and restartpoints

2010-01-13 Thread Fujii Masao
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

Re: [HACKERS] Incrementally Updated Backups and restartpoints

2010-01-13 Thread Heikki Linnakangas
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

Re: [HACKERS] Incrementally Updated Backups and restartpoints

2010-01-13 Thread Fujii Masao
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