pgsql: Make recovery from WAL be restartable, by executing a - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Make recovery from WAL be restartable, by executing a
Date
Msg-id 20060807165757.62B769FB1BA@postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pgsql: Add support for forcing a switch to a new
Next
From: dpavlin@pgfoundry.org (User Dpavlin)
Date:
Subject: pgestraier - pgestraier: print example SQL search query at end