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