RE: [EXT] Re: High Availability

Other options to consider:

1. Region 1: AWS Aurora Postgres with 1 writer and 1 reader node.
2. Region 2: Same as above.
3. Choose a 3rd party tool or use pg-logical to replicate data between Region 1 and Region 2 so that they are always in sync.

Please note, your app tier should align with these.

Thank you
Kam

From: Mauricio Fernandez <mmauricio(dot)fernandez(at)gmail(dot)com>
Sent: Thursday, January 23, 2025 1:01 PM
To: Gabriel Guillem Barceló Soteras <gbarcelo(at)parlamentib(dot)es>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: [EXT] Re: High Availability

External Email: Use caution with links and attachments.

Thank you ver much for answering Gabriel

Kind regards

MF

El jue, 23 ene 2025 a las 10:15, Gabriel Guillem Barceló Soteras (<gbarcelo(at)parlamentib(dot)es<mailto:gbarcelo(at)parlamentib(dot)es>>) escribió:
I think there is no gold-standard HA solution. Some commercial PostgreSQL offer HA as an add-on or standalone product, and they tackle different SPOFs with varying components. If you got the open source way, a good starting point is https://www.postgresql.org/docs/current/high-availability.html<https://urldefense.com/v3/__https:/www.postgresql.org/docs/current/high-availability.html__;!!GFN0sa3rsbfR8OLyAw!dhfoUPtDH6FZwXhbfJ_P1rSGtEq9N1yRApA86OJ1Mu8lHWAx0hHIUK365bbHBqOUTzUx5klpx2V-bnb58BHlln8nxrCLq2m1-wgq$>

Depending on your requirements you may go one route or another. For exemple, it may be ok for you a single pgpool-2 instance, without front Haproxy tier.

We tested some of them, and we don’t use any of them so far. In our scenario we can assume some out of office downtime for maintenance tasks.

Good luck,
Gabriel

From: Mauricio Fernandez <mmauricio(dot)fernandez(at)gmail(dot)com<mailto:mmauricio(dot)fernandez(at)gmail(dot)com>>
Date: Thursday, 23 January 2025 at 02:20
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)org>>
Subject: High Availability
Hi admins, I need to know if anybody know about some survey, poll, web site, etc talking about most popular postgresql's most popular high availability solutions.

Using repmgrd, with or without pgpool-ii, haproxy, etc.., commercial or free.

Thanks in advance

regards

Mauricio Fernández