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

From: John Smith <jayzee(dot)smith(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: how to delay sync by a set time, hour or day?
Date: 2014-11-18 23:37:11
Message-ID: CAMZ8qd_hmFu8szGoyUV-tXsrEJaTXb=hZ98kk8AUgCw5VfuBYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-11-18 23:43:14 Re: issue with double ordering in a wrapped distinct
Previous Message Jonathan Vanasco 2014-11-18 23:35:44 issue with double ordering in a wrapped distinct