Re: Postgresql version of SQL Server Availability Groups?

Поиск
Список
Период
Сортировка
От Frédéric Boulet
Тема Re: Postgresql version of SQL Server Availability Groups?
Дата
Msg-id CAHuOqjME8P-UQpbM8kHN_623Ebos2kwxvGbQD44y2-ncBcwwvA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql version of SQL Server Availability Groups?  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-admin
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


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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Postgresql version of SQL Server Availability Groups?
Следующее
От: Holger Jakobs
Дата:
Сообщение: Re: server setting up error