On Wed, Nov 19, 2014 at 8:37 AM, John Smith <jayzee.sm...@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
