Re: PostgreSQL Automatic Failover Windows Server

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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.