repmgr cascade replication node delay
Hi guys,
I have a replication scenario master/slave and I would like to create one extra more node (cascade from slave) with a time delay of 24-hour replication.
The objective of an extra node 24 hours delayed is to recover some error in the server.
Is it possible to make this configuration?
Open to suggestions, please ignore pg_dump and barman.
Regards
Juliano
On Thu, Jun 1, 2017 at 3:30 PM, Juliano <jplinux@protonmail.com> wrote:
The objective of an extra node 24 hours delayed is to recover some error
in the server.
Is it possible to make this configuration?
A quick search turns up:
recovery_min_apply_delay
https://www.postgresql.org/docs/current/static/standby-settings.html
No personal experience though.
David J.
Hi David,
Thanks for your email.
This recovery_min_apply_delay sounds interesting!
I wold like to use it between 2 standby nodes (cascade replication using repmgr) instead of master/standby, anyone knows if is it possible?
Regards,
Juliano
Sent with [ProtonMail](https://protonmail.com) Secure Email.
-------- Original Message --------
Subject: Re: [GENERAL] repmgr cascade replication node delay
Local Time: June 1, 2017 11:42 PM
UTC Time: June 1, 2017 10:42 PM
From: david.g.johnston@gmail.com
To: Juliano <jplinux@protonmail.com>
pgsql-general@postgresql.org <pgsql-general@postgresql.org>, pgsql-general-owner@postgresql.org <pgsql-general-owner@postgresql.org>
On Thu, Jun 1, 2017 at 3:30 PM, Juliano <jplinux@protonmail.com> wrote:
The objective of an extra node 24 hours delayed is to recover some error in the server.
Is it possible to make this configuration?
A quick search turns up:
recovery_min_apply_delay
https://www.postgresql.org/docs/current/static/standby-settings.html
No personal experience though.
David J.