Proposal: Native High Availability and Automatic Failover in PostgreSQL

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