PostgreSQL HA Cluster
PostgreSQL is an open-source object-relational database that extends standard SQL with advanced data types, indexing, and transactional integrity; high-availability deployments layer streaming replication and automated failover on top of its core engine.
Baseline topologies
| Topology | Minimum nodes | Roles |
|---|---|---|
| primary-plus-replicas | 2 | primary, replica |
| primary-plus-two-replicas | 3 | primary, replica |
What drives the cost
- Writable primary nodes
- Number of writable primary nodes in the topology. Conservative HA guidance assumes this stays at 1.
- Replica nodes
- Number of replica nodes available for failover and read scaling.
- Logical dataset size (GB)
- Estimated logical dataset size before replication overhead.
Where it runs
bare_metal, dedicated, cloud_vm
Size PostgreSQL HA Cluster and get a cost estimate