how to delay sync by a set time, hour or day?

Поиск
Список
Период
Сортировка
От John Smith
Тема how to delay sync by a set time, hour or day?
Дата
Msg-id CAMZ8qd_hmFu8szGoyUV-tXsrEJaTXb=hZ98kk8AUgCw5VfuBYQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to delay sync by a set time, hour or day?  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-general
i want to setup a standby slave that listens 24/7 but only syncs when told to.

setting "pause_at_recovery_target (boolean)" in recovery.conf on slave
doesn't help since docs say it only "specifies whether recovery should
pause when the recovery target is reached."

also "recovery_target = 'immediate'" is the only value allowed.

i want to delay sync by a set time, hour or day.

how?

http://www.postgresql.org/docs/9.3/static/recovery-target-settings.html

thks, jzs


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

Предыдущее
От: Jonathan Vanasco
Дата:
Сообщение: issue with double ordering in a wrapped distinct
Следующее
От: Tom Lane
Дата:
Сообщение: Re: issue with double ordering in a wrapped distinct