| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Open source HA setup for postgres |
| Date: | 2022-10-16 02:11:28 |
| Message-ID: | 15f921c7-e6c6-8a88-1895-02a62d41118c@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
--
Angular momentum makes the world go 'round.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | edi mari | 2022-10-19 12:25:38 | Database schema changes tools |
| Previous Message | Ron | 2022-10-16 02:07:55 | Re: Open source HA setup for postgres |