| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | harding(dot)ian(at)gmail(dot)com |
| Cc: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Log Apply Delay |
| Date: | 2011-09-16 15:33:17 |
| Message-ID: | 1316187197.2939.11.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2011-09-16 15:35:43 | Re: Log Apply Delay |
| Previous Message | Ian Harding | 2011-09-16 15:02:31 | Log Apply Delay |