Re: Investigate postgres 9.6.3 repmgr lag 4.0.4 - Mailing list pgsql-admin

From Mariel Cherkassky
Subject Re: Investigate postgres 9.6.3 repmgr lag 4.0.4
Date
Msg-id CA+t6e1n0moY-sVxgKn+giq=q-zV89nVVxdyyp5_W1QrwbXAN8Q@mail.gmail.com
Whole thread Raw
In response to Re: Investigate postgres 9.6.3 repmgr lag 4.0.4  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Investigate postgres 9.6.3 repmgr lag 4.0.4  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Re: Investigate postgres 9.6.3 repmgr lag 4.0.4  (Rui DeSousa <rui@crazybean.net>)
List pgsql-admin
To be honest I used most of the default settings of repmgr and didnt focus on replication slot because I didnt saw that is was mentioned in the documentation. I will schedule soon a maintenance work to upgrade the cluster to version 10. I dont have any firewalls between all the nodes. So the optimal use is configure replication slot. Another question ,  "have it fail over to using the archived WALs instead of full database restore" How do I configure this ?

Thanks , Mariel.

2018-06-24 19:37 GMT+03:00 Ron <ronljohnsonjr@gmail.com>:
On 06/24/2018 11:22 AM, Flavio Henrique Araque Gurgel wrote:
[snip]

Actually there are just two simple questions for the OP: Why you're not running the latest 9.6

Besides "he hasn't gotten around to it", there are companies that allocate a few hours of downtime once per year (usually on Christmas Day) for critical databases managing process control in factories.

--
Angular momentum makes the world go 'round.

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Reading on how materialized views are materialized?
Next
From: Mariel Cherkassky
Date:
Subject: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4