Re: [EXT] Re: High Availability

Thank you very much for the answer Kam

Kind regards

MF

El jue, 23 ene 2025 a las 16:47, Wong, Kam Fook (TR Technology) (<
kamfook(dot)wong(at)thomsonreuters(dot)com>) escribió:

> 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>) 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>
> *Date: *Thursday, 23 January 2025 at 02:20
> *To: *Pgsql-admin <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
>
>