Re: Log Apply Delay

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Log Apply Delay
Дата
Msg-id 20110916153543.GB11550@depesz.com
обсуждение исходный текст
Ответ на Log Apply Delay  (Ian Harding <harding.ian@gmail.com>)
Ответы Re: Log Apply Delay
Список pgsql-general
On Fri, Sep 16, 2011 at 08:02:31AM -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?

In streaming - no. But if you want delay, perhaps normal WAL-files based
approach would be good enough? OmniPITR, for one, has a option to delay
applying wal segments.

Best regards,

depesz


В списке pgsql-general по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Log Apply Delay
Следующее
От: Ian Harding
Дата:
Сообщение: Re: Log Apply Delay