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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Thu, 23 Oct 2008 18:11:24 +0100
  • Message-id: <1224781884.27145.645.camel@ebony.2ndQuadrant> <text/plain>

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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group