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 |
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 |
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 |