| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postresql HA 2 nodes |
| Date: | 2023-05-16 21:36:45 |
| Message-ID: | 3138126f-e6f6-bade-e5ce-c3da3d2c1edb@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 5/16/23 16:30, Marcello Lorenzi wrote:
> Hi everyone,
> we're looking for the best solution for a 2-nodes cluster in HA with
> Postegresql 15. after some checks we are noticed about pgpool for the
> management of balancing and automatic failover. Can it be considered a
> viable and manageable solution for production?
I implemented a 2/3-node HA system with Postgresql 13 and PgPool. Not in
production yet, but seems stable.
By 2/3, I mean that there are 2 Pg nodes, and PgPool is installed on them
plus a 3rd (smaller) VM. You really need 3 nodes for quorum voting.
--
Born in Arizona, moved to Babylonia.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2023-05-16 23:39:50 | Re: "PANIC: could not open critical system index 2662" - twice |
| Previous Message | Marcello Lorenzi | 2023-05-16 21:30:42 | Postresql HA 2 nodes |