From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | John Smith <jayzee(dot)smith(at)gmail(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: how to delay sync by a set time, hour or day? |
Date: | 2014-11-19 05:17:17 |
Message-ID: | CAB7nPqQYqMO3GJzmzaco8AQ3YOnDXc4WCrBOBG0YeEdL3buiwQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Nov 19, 2014 at 8:37 AM, John Smith <jayzee(dot)smith(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Yanrui Hu | 2014-11-19 05:36:14 | Re: About the tps explanation of pgbench, please help |
Previous Message | Adrian Klaver | 2014-11-19 02:58:39 | Re: About the tps explanation of pgbench, please help |