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

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Ale Rox <gitroxale(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Proposal: Native High Availability and Automatic Failover in PostgreSQL
Date: 2025-06-25 15:33:16
Message-ID: CAKAnmmJX7Uw-zwNqpzRATjusnR1JwSwy0-D3s487gTPSgY6b3A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 25, 2025 at 3:26 AM Ale Rox <gitroxale(at)gmail(dot)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(at)mail(dot)gmail(dot)com

--
Cheers,
Greg

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2025-06-25 15:39:08 Re: pg_dump misses comments on NOT NULL constraints
Previous Message Greg Sabino Mullane 2025-06-25 15:30:31 Re: Proposal: Native High Availability and Automatic Failover in PostgreSQL