pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql version of SQL Server Availability Groups?
4+ messages / 3 participants
[nested] [flat]
* Postgresql version of SQL Server Availability Groups?
@ 2022-09-18 14:58 Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Ron @ 2022-09-18 14:58 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql version of SQL Server Availability Groups?
@ 2022-09-18 19:23 Licio Matos <licio.matos@gmail.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Licio Matos @ 2022-09-18 19:23 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi Ron!
Look if pgpool can handle your request
https://www.pgpool.net/docs/37/en/html/example-cluster.html
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql version of SQL Server Availability Groups?
@ 2022-09-18 21:47 Ron <ronljohnsonjr@gmail.com>
parent: Licio Matos <licio.matos@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Ron @ 2022-09-18 21:47 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Quite possibly.
Thank you.
On 9/18/22 14:23, Licio Matos wrote:
> Hi Ron!
>
> Look if pgpool can handle your request
>
> https://www.pgpool.net/docs/37/en/html/example-cluster.html
>
>
> 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql version of SQL Server Availability Groups?
@ 2022-09-19 07:26 Frédéric Boulet <boulet.f@gmail.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Frédéric Boulet @ 2022-09-19 07:26 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hello,
I confirm that pg_pool is a HA solution.
It handles also load_balancing but it can be disabled : "load_balance_mode
=off "
I recommend pg_pool v4.2 (at least) , much more easy to configure (same
config file on all nodes).
I already use it as a HA solution between 2 nodes (with PG replication),
but be careful with some parameters :
"
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
>
> https://www.pgpool.net/docs/37/en/html/example-cluster.html
>
>
> 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.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-09-19 07:26 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-09-18 14:58 Postgresql version of SQL Server Availability Groups? Ron <ronljohnsonjr@gmail.com>
2022-09-18 19:23 ` Licio Matos <licio.matos@gmail.com>
2022-09-18 21:47 ` Ron <ronljohnsonjr@gmail.com>
2022-09-19 07:26 ` Frédéric Boulet <boulet.f@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox