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