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 <gitrox...@gmail.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 >
