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,
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.
Thanks,
Vijay
Mumbai, India