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

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 (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-generalpgsql-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

pgsql-hackers by date

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

pgadmin-hackers by date

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

pgsql-general by date

Next:From: Alvaro HerreraDate: 2008-10-23 17:15:37
Subject: Re: Annoying Reply-To
Previous:From: Bruce MomjianDate: 2008-10-23 17:01:22
Subject: Re: Annoying Reply-To

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