Restartable Recovery

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Marko Kreen <markokr(at)gmail(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Restartable Recovery
Date: 2006-07-11 16:55:46
Message-ID: 1152636947.2465.14.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


On Marko Kreen's detailed suggestion, I've implemented a restartable
recovery mode for archive recovery (aka PITR). Restart points are known
as recovery checkpoints and are normally taken every 100 checkpoints in
the log to ensure good recovery performance.

An additional mode
standby_mode = 'true'
can also be specified, which ensures that a recovery checkpoint occurs
for each checkpoint in the logs.

Some other code refactorings, though all changes isolated to xlog.c and
to pg_control.h; code comments welcome.

Applies cleanly to cvstip, passes make check.

Further details testing is very desirable. I've tested restarting a
recovery twice and things work successfully.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

Attachment Content-Type Size
restartableRecovery.patch text/x-patch 14.5 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-07-11 16:59:55 Re: Three weeks left until feature freeze
Previous Message Josh Berkus 2006-07-11 16:55:12 Re: More nuclear options

Browse pgsql-patches by date

  From Date Subject
Next Message Dhanaraj M 2006-07-11 19:36:13 Re: Patch for - Change LIMIT/OFFSET to use int8
Previous Message Tom Lane 2006-07-11 16:16:05 Re: Patch to "configure" to enable PostgreSQL build with Kerberos 5 on Solaris 11