Postgres Pro
Downloads
Home   >   mailing lists

how to delay sync by a set time, hour or day? - Mailing list pgsql-general

From John Smith
Subject how to delay sync by a set time, hour or day?
Date
Msg-id CAMZ8qd_hmFu8szGoyUV-tXsrEJaTXb=hZ98kk8AUgCw5VfuBYQ@mail.gmail.com
Whole thread Raw
Responses Re: how to delay sync by a set time, hour or day?  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Jonathan Vanasco
Date:
Subject: issue with double ordering in a wrapped distinct
Next
From: Tom Lane
Date:
Subject: Re: issue with double ordering in a wrapped distinct