Incrementally Updated Backups and restartpoints

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Incrementally Updated Backups and restartpoints
Date: 2010-01-13 11:36:02
Message-ID: 4B4DB022.4070209@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

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 process from the last restart point. We no longer need to keep WAL files from before the restart point. If we need to recover, it will be faster to recover from the incrementally updated backup than from the original base backup.

That doesn't seem safe. If the server makes a new restartpoint while the
backup is running, and pg_control is backed up after the new
restartpoint is made, recovery will restart from the new restartpoint.
That is wrong; recovery needs to restart at the restartpoint that was
most recent when the backup started. This is basically the same issue we
have solved in master with the backup_label file.

I wonder if it would be enough to document that pg_control must be
backed up first?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Fujii Masao 2010-01-13 11:57:37 Re: Incrementally Updated Backups and restartpoints
Previous Message Andrew Lardinois 2010-01-07 09:32:39 include no validation of XML schema in 8.13.1- the XML Type

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2010-01-13 11:57:37 Re: Incrementally Updated Backups and restartpoints
Previous Message Tim Bunce 2010-01-13 11:30:13 Re: Feature patch 1 for plperl [PATCH]