On Fri, Oct 24, 2014 at 8:01 PM, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:
On Fri, Oct 24, 2014 at 12:30 AM, John Smith <jayzee.smith@xxxxxxxxx> wrote:
>
> i want to setup a warm standby that listens 24/7 but only syncs when
> told to (ie only when i am ok with the database updates, will i
> trigger the sync).
> can i?
>
> i don't want to manually backup and restore like i do now.
That's what pause_at_recovery_target is aimed for:
http://www.postgresql.org/docs/devel/static/recovery-target-settings.html
Simply set up the recovery target you want to check, and use
pause_at_recovery_target to put the standby in a latent state you can
check. If the state of your server does not satisfy your needs,
shutdown the server and change the target. Note that operations are
not backward btw.
If you were using hot-standby, you could have used pg_pause_recovery() / pg_resume_recovery()
To pause when needed and continue later. e.g. when you are doing bulk loads or during a window when you see network congestion.
Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
