Re: Log Apply Delay - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Log Apply Delay
Date
Msg-id 1316187197.2939.11.camel@localhost.localdomain
Whole thread Raw
In response to Log Apply Delay  (Ian Harding <harding.ian@gmail.com>)
List pgsql-general
On Fri, 2011-09-16 at 08:02 -0700, Ian Harding wrote:
> Oracle has a configuration option for its version of hot standby
> (DataGuard) that lets you specify a time based delay in applying logs.
>  They get transferred right away, but changes in them are only applied
> as they reach a certain age.  The idea is that if something horrible
> happens on the master, you can keep it from propagating to one or more
> of your standby databases (or keep from having to reinstate one in the
> case of a failover)
>
> Anyway, Is there any plan to add a knob like that to the streaming
> replication in Postgres?
>

IIRC, Robert Haas had a WIP patch to do that. Not sure what its status
is now.


--
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com


pgsql-general by date:

Previous
From: Ian Harding
Date:
Subject: Log Apply Delay
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Log Apply Delay