Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Nov 19, 2014 at 8:37 AM, John Smith <jayzee.smith@xxxxxxxxx> wrote:
>
> 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

Aren't pg_xlog_replay_pause and pg_xlog_replay_resume what you are looking for?
http://www.postgresql.org/docs/devel/static/functions-admin.html#FUNCTIONS-RECOVERY-CONTROL
-- 
Michael


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux