pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOpen source HA setup for postgres
4+ messages / 3 participants
[nested] [flat]
* Open source HA setup for postgres
@ 2022-10-14 16:33 Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>
0 siblings, 3 replies; 4+ messages in thread
From: Tharmarajah, Sam @ 2022-10-14 16:33 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi,
We are wondering what is open-source tools being used to set up the HA. We are also looking for a way to pass the reads to all the HA nodes and writes to the primary. One of the pressing criteria is the HA also should be able to handle the node being taken down during patching and should be able to fail back or recover seamlessly without any manual intervention.
This is the first time we are embarking on HA, so would like some advice and caveats to avoid.
Thanx
Sam
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Open source HA setup for postgres
@ 2022-10-15 18:18 Holger Jakobs <holger@jakobs.com>
parent: Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>
2 siblings, 0 replies; 4+ messages in thread
From: Holger Jakobs @ 2022-10-15 18:18 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi Sam,
There is a whole chapter about this topic in the official documentation
https://www.postgresql.org/docs/current/high-availability.html
Plus, there are products like pg_auto_failover by Citus (Microsoft) and
the template Patroni.
Regards,
Holger
Am 14.10.22 um 18:33 schrieb Tharmarajah, Sam:
>
> Hi,
>
> We are wondering what is open-source tools being used to set up the
> HA. We are also looking for a way to pass the reads to all the HA
> nodes and writes to the primary. One of the pressing criteria is the
> HA also should be able to handle the node being taken down during
> patching and should be able to fail back or recover seamlessly without
> any manual intervention.
>
> This is the first time we are embarking on HA, so would like some
> advice and caveats to avoid.
>
> Thanx
>
> Sam
>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Open source HA setup for postgres
@ 2022-10-16 02:07 Ron <ronljohnsonjr@gmail.com>
parent: Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>
2 siblings, 0 replies; 4+ messages in thread
From: Ron @ 2022-10-16 02:07 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 10/14/22 11:33, Tharmarajah, Sam wrote:
>
> Hi,
>
> We are wondering what is open-source tools being used to set up the HA. We
> are also looking for a way to pass the reads to all the HA nodes and
> writes to the primary. One of the pressing criteria is the HA also should
> be able to handle the node being taken down during patching and should be
> able to fail back or recover seamlessly without any manual intervention.
>
> This is the first time we are embarking on HA, so would like some advice
> and caveats to avoid.
>
What I'm currently looking at is this combo:
https://repmgr.org/ (for quorum voting, fail over *and seamless fail back*)
https://pgpool.net/mediawiki/index.php/Main_Page (for a common IP address)
On a switchover (whether planned or unplanned), repgmr reconfigures PgPool
to use the New-primary's IP address.
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Open source HA setup for postgres
@ 2022-10-16 02:11 Ron <ronljohnsonjr@gmail.com>
parent: Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>
2 siblings, 0 replies; 4+ messages in thread
From: Ron @ 2022-10-16 02:11 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 10/14/22 11:33, Tharmarajah, Sam wrote:
>
> Hi,
>
> We are wondering what is open-source tools being used to set up the HA. We
> are also looking for a way to pass the reads to all the HA nodes and
> writes to the primary. One of the pressing criteria is the HA also should
> be able to handle the node being taken down during patching and should be
> able to fail back or recover seamlessly without any manual intervention.
>
> This is the first time we are embarking on HA, so would like some advice
> and caveats to avoid.
>
I meant PgBouncer, not PgPool. No SELECT load balancing, though.
https://www.pgbouncer.org/
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-10-16 02:11 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-14 16:33 Open source HA setup for postgres Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>
2022-10-15 18:18 ` Holger Jakobs <holger@jakobs.com>
2022-10-16 02:07 ` Ron <ronljohnsonjr@gmail.com>
2022-10-16 02:11 ` Ron <ronljohnsonjr@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