Re: Proposal: Native High Availability and Automatic Failover in PostgreSQL

Greg Sabino Mullane <htamfids@gmail.com>

From: Greg Sabino Mullane <htamfids@gmail.com>
To: Ale Rox <gitroxale@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-06-25T15:33:16Z
Lists: pgsql-hackers
On Wed, Jun 25, 2025 at 3:26 AM Ale Rox <gitroxale@gmail.com> wrote:

> - A JDBC driver (and ideally other drivers as well) that accepts a list of
> nodes in the connection string and can automatically detect the current
> primary node for write operations — similar to how MongoDB drivers handle
> replica sets.
>

This one could be done with the help of one of my outstanding patches:

https://www.postgresql.org/message-id/flat/CAKAnmm+T-CEDLmRezWfH-7ZEsFfD_kU2KY1TgB288K+wprB_4Q@mail.gmail.com


-- 
Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support