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)
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!
