Thread: Postresql HA 2 nodes
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?
Thanks,
Marcello
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.
On Tue, 16 May 2023 23:30:42 +0200 Marcello Lorenzi <cello86@gmail.com> 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? Have a look at this recent discussion which discuss various solutions, pros and cons: https://www.postgresql.org/message-id/flat/AM9P251MB033074BFEBB9AA40955B5B7598929%40AM9P251MB0330.EURP251.PROD.OUTLOOK.COM Regard,