0

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?

Mohammed Alali
  • 7
  • 2
  • 2
    "*Does Postgres 14 need third-party software to do automatic failover?*" - yes. Which you could have easily found out yourself by reading the manual –  Jun 26 '22 at 14:20
  • PostgreSQL (like MySQL) is a single instance database (vs MongoDB, cassandra...) you need a custer manager (like pacemaker) to build a high availability architecture – mshabou Jun 26 '22 at 15:06
  • I’m voting to close this question because Google can answer this question in half a second – Frank Heikens Jun 26 '22 at 17:09

1 Answers1

0

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.
Phạm Ngọc Quý
  • 249
  • 2
  • 7