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.
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. |