| 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: | Whole Thread | Raw Message | 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
| 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? | 
| 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 | 
| 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 |