Skip site navigation (1) Skip section navigation (2)

pgsql: Add recovery_end_command option to recovery.conf.

From: heikki(at)postgresql(dot)org (Heikki Linnakangas)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add recovery_end_command option to recovery.conf.
Date: 2009-05-14 20:31:09
Message-ID: 20090514203109.8EBA2754067@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Log Message:
-----------
Add recovery_end_command option to recovery.conf. recovery_end_command
is run at the end of archive recovery, providing a chance to do external
cleanup. Modify pg_standby so that it no longer removes the trigger file,
that is to be done using the recovery_end_command now.

Provide a "smart" failover mode in pg_standby, where we don't fail over
immediately, but only after recovering all unapplied WAL from the archive.
That gives you zero data loss assuming all WAL was archived before
failover, which is what most users of pg_standby actually want.

recovery_end_command by Simon Riggs, pg_standby changes by Fujii Masao and
myself.

Modified Files:
--------------
    pgsql/src/backend/access/transam:
        xlog.c (r1.337 -> r1.338)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1.337&r2=1.338)
    pgsql/contrib/pg_standby:
        pg_standby.c (r1.21 -> r1.22)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_standby/pg_standby.c?r1=1.21&r2=1.22)
    pgsql/doc/src/sgml:
        backup.sgml (r2.125 -> r2.126)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/backup.sgml?r1=2.125&r2=2.126)
        pgstandby.sgml (r2.7 -> r2.8)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/pgstandby.sgml?r1=2.7&r2=2.8)

Responses

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2009-05-14 20:31:18
Subject: Re: New trigger option of pg_standby
Previous:From: Simon RiggsDate: 2009-05-14 19:10:04
Subject: Re: New trigger option of pg_standby

pgsql-committers by date

Next:From: Alvaro HerreraDate: 2009-05-14 20:39:01
Subject: Re: pgsql: Add recovery_end_command option torecovery.conf.
Previous:From: User BmomjianDate: 2009-05-14 16:29:51
Subject: pg-migrator - pg_migrator: Remove placeholder toast files just before

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group