Обсуждение: pgsql: Add recovery_end_command option to recovery.conf.
pgsql: Add recovery_end_command option to recovery.conf.
От
heikki@postgresql.org (Heikki Linnakangas)
Дата:
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)
Heikki Linnakangas wrote: > 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. I think it's worth documenting this stuff in the release notes so that it shows up for the next beta ... -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Alvaro Herrera wrote: > Heikki Linnakangas wrote: >> 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. > > I think it's worth documenting this stuff in the release notes so that > it shows up for the next beta ... Done. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Heikki Linnakangas wrote:
>> 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.
> I think it's worth documenting this stuff in the release notes so that
> it shows up for the next beta ...
Yeah, on it now. Good work getting the patch in!
regards, tom lane
On Thu, May 14, 2009 at 3:31 PM, Heikki Linnakangas <heikki@postgresql.org> wrote: > 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. > maybe we want to update share/recovery.conf.sample too? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157
Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> maybe we want to update share/recovery.conf.sample too?
Good catch, done.
regards, tom lane
Tom Lane wrote: > Alvaro Herrera <alvherre@commandprompt.com> writes: >> Heikki Linnakangas wrote: >>> 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. > >> I think it's worth documenting this stuff in the release notes so that >> it shows up for the next beta ... > > Yeah, on it now. Good work getting the patch in! Albeit a bit hasty. Thanks for the cleanups. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com