PostgreSQL HA Cluster equivalent to SQL Server Availability Group Listener object
0
votes
1
answer
99
views
I've setup a PostgreSQL v16.6 HA Cluster using
repmgr
. Ensured replication is working between primary and standby nodes. Then I tried simulating a failover event by shutting down PostgreSQL service at the primary node and saw cluster switched to standby node. However, the application using this cluster reported the database was down.
Apparently, the app needs to use kind of a listener/monitor object connection URL instead of a direct primary node IP address to connect to DB. This can be an equivalent of MS SQL Server Availability Group Listener .
However, I don't seem to find the name of this object/component in PostgreSQL world. In PostgreSQL it seems like there is more than one way to setup HA replication cluster between nodes: repmgr
, pgPool-II
, probably some others. So it is a bit confusing.
Could you please advise what component/package to use which would make PostgreSQL Cluster failovers transparent to the apps? And what the connection URL should be for apps in this case to connect to the PG SQL Cluster and not care which node is currently the primary one?
Asked by andrews
(175 rep)
Jan 9, 2025, 02:35 PM
Last activity: Jan 9, 2025, 03:03 PM
Last activity: Jan 9, 2025, 03:03 PM