Thread: [GENERAL] 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
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
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?
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 Secure Email.
-------- Original Message --------Subject: Re: [GENERAL] repmgr cascade replication node delayLocal Time: June 1, 2017 11:42 PMUTC Time: June 1, 2017 10:42 PMFrom: david.g.johnston@gmail.comTo: Juliano <jplinux@protonmail.com>pgsql-general@postgresql.org <pgsql-general@postgresql.org>, pgsql-general-owner@postgresql.org <pgsql-general-owner@postgresql.org>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_delayNo personal experience though.David J.