Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] repmgr cascade replication node delay - Mailing list pgsql-general

From Juliano
Subject Re: [GENERAL] repmgr cascade replication node delay
Date
Msg-id Sym4SWBI87KMrCCzPHiPL5gY1DcrBGoSoFiVkdn1mJYbxEIIuKiFJEFxWGH9rUQHcX4EPqbgRnfluIFBiVMnfYt1WkxmbA4nNzjiQWCsq2M=@protonmail.com
Whole thread Raw
In response to Re: [GENERAL] repmgr cascade replication node delay  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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@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.



pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.
Next
From: stevenchang1213
Date:
Subject: Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.