Re: [HELP] Query regarding failover - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: [HELP] Query regarding failover
Date
Msg-id 9f08d0b2aeb76d9775acf18b6bb70fac0ae51d2b.camel@cybertec.at
Whole thread Raw
In response to [HELP] Query regarding failover  (Praveen Kumar K S <praveenssit@gmail.com>)
Responses Re: [HELP] Query regarding failover  (Praveen Kumar K S <praveenssit@gmail.com>)
List pgsql-admin
On Tue, 2020-06-30 at 20:54 +0530, Praveen Kumar K S wrote:
> My requirement is to set up a process to handle failover and recovery without manual intervention.
> I would like to know your suggestions if there is any standard way of doing this or is it better to write custom
scripts.

I don't think you can do that reliably with "custom scripts".
There is no standard way, but have a look at Patroni.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-admin by date:

Previous
From: Marlene Villanueva
Date:
Subject: Re: pg_basebackup compression
Next
From: Mai Peng
Date:
Subject: Re: After renaming a database the subscription ( logical replication) stay sticky to the old database (master)