Re: High Availability

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
>
>
>
> 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
>