Re: [HACKERS] Hot Standby utility and administrator functions

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: pgadmin-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] Hot Standby utility and administrator functions
Date: 2008-10-23 17:11:24
Message-ID: 1224781884.27145.645.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-general pgsql-hackers


On Mon, 2008-10-20 at 10:25 +0100, Simon Riggs wrote:

> What else do we need?

> * pg_freeze_recovery()
> * pg_unfreeze_recovery()

Two more functions

pg_freeze_recovery_cleanup()
pg_unfreeze_recovery_cleanup()

These would allow recovery to continue normally, except for row removal
operations which would halt the progress of recovery.

It would eventually be possible to have a function that halts recovery
whenever row removal takes place for a list of tables. Not planning on
implementing that initially though.

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-10-23 17:16:26 Re: [HACKERS] Hot Standby utility and administrator functions
Previous Message Dave Page 2008-10-22 08:20:26 Re: website down?

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-10-23 17:15:37 Re: Annoying Reply-To
Previous Message Bruce Momjian 2008-10-23 17:01:22 Re: Annoying Reply-To

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-10-23 17:16:26 Re: [HACKERS] Hot Standby utility and administrator functions
Previous Message Tom Lane 2008-10-23 16:54:22 Re: double-buffering page writes