Re: repmgr cascade replication node delay

[Juliano <jplinux@xxxxxxxxxxxxxx>]

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 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@xxxxxxxxx

To: Juliano <jplinux@xxxxxxxxxxxxxx>

pgsql-general@xxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxx>, pgsql-general-owner@xxxxxxxxxxxxxx <pgsql-general-owner@xxxxxxxxxxxxxx>

On Thu, Jun 1, 2017 at 3:30 PM, Juliano <jplinux@xxxxxxxxxxxxxx> 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.