Automatic Failover in postgreSQL 14

Question

I have read that PostgreSQL doesn't detect server failure so it doesn't do automatic failover, but all the articles were in 2020 (two years ago).

My question is Does Postgres 14 need third-party software to do automatic failover? or is it built-in now?

Answer 1

I can suggest to you some of the third-party software I have done before:

1. repmgr: Infact, it's not automatic failover in case I have one master and 1 slave.
2. patroni: That is quite good.