On Wed, Aug 18, 2021 at 11:57:24PM +0530, Vijaykumar Jain wrote: > > I want to know in detail about PostgreSQL Automatic Failover solutions > without third party tools. > > There is no automatic failover solution provided with core postgresql. (maybe > EDB provides in windows but ...) > there are third party OSS solutions, > dhamaniasad/awesome-postgres: A curated list of awesome PostgreSQL software, > libraries, tools and resources, inspired by awesome-mysql (github.com) > These are a few solutions for HA. > There are detailed docs for each and/or blogs, you will have to read them to > figure out which one suits you best. Yes, I think the reason there are only third-party failover tools is that failover is very tied to the operating system/network details, and the database usually doesn't focus on those. -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.