Обсуждение: Postgresql version of SQL Server Availability Groups?
Currently my customer has some very large stand-alone PostgreSQL 9.6 (will migrate next year to v13) databases, and they want to add HA.
Specifically, they want a "cluster name" which points to a Primary database server's IP address, and and which automatically (presumably through through a heartbeat and quorum voting system) points to a Secondary database server's IP address if the Primary server goes down. Both servers are in the same data center. (Replication would be handled by a standard PostgreSQL method.)
This is not load balancing, but a purely HA solution.
I looked at HAProxy, but it seems to be focused on load balancing, while the Patroni documentation does not seem to mention a cluster name.
Am I missing something?
Specifically, they want a "cluster name" which points to a Primary database server's IP address, and and which automatically (presumably through through a heartbeat and quorum voting system) points to a Secondary database server's IP address if the Primary server goes down. Both servers are in the same data center. (Replication would be handled by a standard PostgreSQL method.)
This is not load balancing, but a purely HA solution.
I looked at HAProxy, but it seems to be focused on load balancing, while the Patroni documentation does not seem to mention a cluster name.
Am I missing something?
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
Hi Ron!
Look if pgpool can handle your request
Em dom., 18 de set. de 2022 às 11:58, Ron <ronljohnsonjr@gmail.com> escreveu:
Currently my customer has some very large stand-alone PostgreSQL 9.6 (will migrate next year to v13) databases, and they want to add HA.
Specifically, they want a "cluster name" which points to a Primary database server's IP address, and and which automatically (presumably through through a heartbeat and quorum voting system) points to a Secondary database server's IP address if the Primary server goes down. Both servers are in the same data center. (Replication would be handled by a standard PostgreSQL method.)
This is not load balancing, but a purely HA solution.
I looked at HAProxy, but it seems to be focused on load balancing, while the Patroni documentation does not seem to mention a cluster name.
Am I missing something?--
Angular momentum makes the world go 'round.
Licio Matos
Quite possibly.
Thank you.
Thank you.
On 9/18/22 14:23, Licio Matos wrote:
Hi Ron!Look if pgpool can handle your request--Em dom., 18 de set. de 2022 às 11:58, Ron <ronljohnsonjr@gmail.com> escreveu:Currently my customer has some very large stand-alone PostgreSQL 9.6 (will migrate next year to v13) databases, and they want to add HA.
Specifically, they want a "cluster name" which points to a Primary database server's IP address, and and which automatically (presumably through through a heartbeat and quorum voting system) points to a Secondary database server's IP address if the Primary server goes down. Both servers are in the same data center. (Replication would be handled by a standard PostgreSQL method.)
This is not load balancing, but a purely HA solution.
I looked at HAProxy, but it seems to be focused on load balancing, while the Patroni documentation does not seem to mention a cluster name.
Am I missing something?--
Angular momentum makes the world go 'round.Licio Matos
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
Hello,
I confirm that pg_pool is a HA solution.I recommend pg_pool v4.2 (at least) , much more easy to configure (same config file on all nodes).
"
failover_when_quorum_exists = on
failover_require_consensus = off
enable_consensus_with_half_votes = on <<===
"
Regards,
Frédéric B.
Le dim. 18 sept. 2022 à 23:48, Ron <ronljohnsonjr@gmail.com> a écrit :
Quite possibly.
Thank you.On 9/18/22 14:23, Licio Matos wrote:Hi Ron!Look if pgpool can handle your request--Em dom., 18 de set. de 2022 às 11:58, Ron <ronljohnsonjr@gmail.com> escreveu:Currently my customer has some very large stand-alone PostgreSQL 9.6 (will migrate next year to v13) databases, and they want to add HA.
Specifically, they want a "cluster name" which points to a Primary database server's IP address, and and which automatically (presumably through through a heartbeat and quorum voting system) points to a Secondary database server's IP address if the Primary server goes down. Both servers are in the same data center. (Replication would be handled by a standard PostgreSQL method.)
This is not load balancing, but a purely HA solution.
I looked at HAProxy, but it seems to be focused on load balancing, while the Patroni documentation does not seem to mention a cluster name.
Am I missing something?--
Angular momentum makes the world go 'round.Licio Matos--
Angular momentum makes the world go 'round.