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

2025-06-25 Thread Greg Sabino Mullane
On Wed, Jun 25, 2025 at 3:26 AM Ale Rox 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

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

2025-06-25 Thread Greg Sabino Mullane
On Wed, Jun 25, 2025 at 3:26 AM Ale Rox wrote: > Specifically, it would be extremely useful to have: > (snip wishlist) > Are there any plans to introduce such functionality in the core > PostgreSQL project in the future? Getting failover to work, and work CORRECTLY[1], is an extremely compli

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

2025-06-25 Thread wenhui qiu
HI Ale Rox I've been thinking like you for a long time, But it's not so easy to realise this, there are more oppositions than approvals,You can search for this title (Re: Built-in Raft replication) On Wed, Jun 25, 2025 at 3:26 PM Ale Rox wrote: > Dear all, > > I've been using PostgreSQL for a