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

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 <gitroxale(at)gmail(dot)com> wrote:

> Dear all,
>
> I've been using PostgreSQL for a long time and consider it a solid and
> reliable database. However, I believe there is room for improvement in the
> area of high availability and automatic failover, inspired by features
> already available in MongoDB.
>
> Specifically, it would be extremely useful to have:
>
> - A built-in mechanism for automatic replication and failover, fully
> integrated into PostgreSQL, without relying on external tools like Patroni;
> - The ability to add new nodes to the cluster with automatic replication
> configuration;
> - Automatic failover behavior when a node goes down, allowing the cluster
> to continue operating, and resynchronizing the node automatically when it
> comes back online;
> - 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.
>
> The goal would be to have a single, fully integrated solution for high
> availability, without needing to assemble multiple external components.
> This would make PostgreSQL significantly easier to manage and more
> competitive in environments where reliability and ease of use are key
> requirements.
>
> Are there any plans to introduce such functionality in the core PostgreSQL
> project in the future?
>
> Thank you for your attention and for the great work you do!
>
> Best regards,
> Rox Ale
>