Re: repmgr cascade replication node delay

From: Juliano <jplinux(at)protonmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-general-owner(at)postgresql(dot)org" <pgsql-general-owner(at)postgresql(dot)org>
Subject: Re: repmgr cascade replication node delay
Date: 2017-06-02 14:03:13
Message-ID: Sym4SWBI87KMrCCzPHiPL5gY1DcrBGoSoFiVkdn1mJYbxEIIuKiFJEFxWGH9rUQHcX4EPqbgRnfluIFBiVMnfYt1WkxmbA4nNzjiQWCsq2M=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)g(dot)johnston(at)gmail(dot)com
To: Juliano <jplinux(at)protonmail(dot)com>
pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>, pgsql-general-owner(at)postgresql(dot)org <pgsql-general-owner(at)postgresql(dot)org>

On Thu, Jun 1, 2017 at 3:30 PM, Juliano <jplinux(at)protonmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stevenchang1213 2017-06-02 15:57:24 Re: Oracle database into PostgreSQL using Ora2PG tool.
Previous Message Igor Neyman 2017-06-02 13:52:46 Re: Oracle database into PostgreSQL using Ora2PG tool.