PostgreSQL Advanced Edition
Last verified 18 Nov 2026
PostgreSQL is an open source, object-relational database built for extensibility, data integrity, and speed. Its concurrency support makes it fully ACID-compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.
DigitalOcean PostgreSQL Advanced Edition is a Managed PostgreSQL architecture with platform-managed leader election for cluster coordination and a connection pooler for routing. It supports highly available workloads and vertical and horizontal scaling of database nodes.
Advanced Edition supports PostgreSQL v16, v17, and v18. New Advanced Edition clusters default to PostgreSQL v18.
High Availability Architecture
PostgreSQL Advanced Edition runs PostgreSQL on managed cluster nodes. A single leader lease managed by the platform determines which node is the primary, rather than a vote among the database nodes. When the primary fails, the platform automatically promotes a standby and coordinates the failover.
PostgreSQL Advanced Edition uses a connection pooler to provide clients with a single, stable service endpoint. The pooler sits in front of the database nodes, tracks which are healthy, pools connections, and routes them to the current primary. When the platform moves the primary to a different node after a failover, the pooler shifts routing so that the hostname and port can stay the same while the backing node changes.
During a failover, active connections to the former primary may be interrupted, but applications that reconnect to the same endpoint are routed to the new primary automatically.
Clusters with standby nodes also provide a separate standby endpoint for read traffic. The primary endpoint does not route queries to standby nodes, because replication to standby nodes is eventually consistent and a standby can lag behind the primary. To send reads to standby nodes, connect to the standby endpoint. See Use Standby Nodes for Reads.
Key Differences
The following table shows the key differences between PostgreSQL Standard and Advanced Edition clusters.
| Feature | PostgreSQL Advanced Edition | PostgreSQL Standard Edition |
|---|---|---|
| Replication model | Streaming replication with platform-managed leader election | Primary-replica streaming replication |
| Failover | Automatic failover using a platform-managed leader lease; connection pooler detects the new primary and routes traffic to it without a DNS cutover wait | Automatic primary promotion; same connection settings; some clients may still reach a former primary until DNS updates propagate (TTL) |
| Connection endpoint | Connection pooler fronts the cluster; the backing node can change without the client changing parameters | Same hostname and parameters; which node those names resolve to after failover depends on DNS timing (possible stale answers or unreachable database until propagation completes) |
| Reads from standby nodes | Separate standby endpoint that load balances each new connection across standby nodes; standby connection pools send pooled reads to standby nodes | replica- hostname that resolves to the standby nodes’ IP addresses, with no load balancing; each connection pool also has standby connection details |
| TLS verification | Requires TLS for all connections and supports verify-full. Uses the system trust store; libpq clients (version 16 or later) require sslrootcert=system. See How to Connect to PostgreSQL Database Clusters and Increase TLS Verification with sslmode. |
Requires TLS for all connections and supports verify-full with a downloaded CA certificate. |
| Topology | Highly available cluster with connection pooler | Primary-replica |
| Node configurations | 1-, 2-, or 3-node | 1-, 2-, or 3-node |
| Best for | Workloads that benefit from pooled, proxy-fronted endpoints and managed high availability | General-purpose managed PostgreSQL workloads |
To create an Advanced Edition cluster, see How to Create PostgreSQL Database Clusters. For limits and features, see PostgreSQL Limits and PostgreSQL Features.