pgsql: Make recovery from WAL be restartable, by executing a

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make recovery from WAL be restartable, by executing a
Date: 2006-08-07 16:57:57
Message-ID: 20060807165757.62B769FB1BA@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Make recovery from WAL be restartable, by executing a checkpoint-like
operation every so often. This improves the usefulness of PITR log
shipping for hot standby: formerly, if the standby server crashed, it
was necessary to restart it from the last base backup and replay all
the WAL since then. Now it will only need to reread about the same
amount of WAL as the master server would. The behavior might also
come in handy during a long PITR replay sequence. Simon Riggs,
with some editorialization by Tom Lane.

Modified Files:
--------------
pgsql/src/backend/access/gin:
ginxlog.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gin/ginxlog.c.diff?r1=1.3&r2=1.4)
pgsql/src/backend/access/gist:
gistxlog.c (r1.22 -> r1.23)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistxlog.c.diff?r1=1.22&r2=1.23)
pgsql/src/backend/access/nbtree:
nbtxlog.c (r1.36 -> r1.37)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtxlog.c.diff?r1=1.36&r2=1.37)
pgsql/src/backend/access/transam:
rmgr.c (r1.23 -> r1.24)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/rmgr.c.diff?r1=1.23&r2=1.24)
xlog.c (r1.246 -> r1.247)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c.diff?r1=1.246&r2=1.247)
pgsql/src/bin/pg_controldata:
pg_controldata.c (r1.29 -> r1.30)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_controldata/pg_controldata.c.diff?r1=1.29&r2=1.30)
pgsql/src/bin/pg_resetxlog:
pg_resetxlog.c (r1.50 -> r1.51)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_resetxlog/pg_resetxlog.c.diff?r1=1.50&r2=1.51)
pgsql/src/include/access:
gin.h (r1.5 -> r1.6)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/gin.h.diff?r1=1.5&r2=1.6)
gist_private.h (r1.22 -> r1.23)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/gist_private.h.diff?r1=1.22&r2=1.23)
nbtree.h (r1.102 -> r1.103)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/nbtree.h.diff?r1=1.102&r2=1.103)
xlog_internal.h (r1.14 -> r1.15)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/xlog_internal.h.diff?r1=1.14&r2=1.15)
pgsql/src/include/catalog:
pg_control.h (r1.30 -> r1.31)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_control.h.diff?r1=1.30&r2=1.31)

Browse pgsql-committers by date

  From Date Subject
Next Message User Dpavlin 2006-08-07 17:05:24 pgestraier - pgestraier: print example SQL search query at end
Previous Message Simon Riggs 2006-08-07 15:34:37 Re: pgsql: Add support for forcing a switch to a new