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.