Database architecture and deployment depends on customer requirements, application demands for high availability, the estimated level of usage, and physical infrastructure. For example, an application that is read-intensive and/or write-intensive could demand 99.999% availability (“five nines”).
There are multiple tools and architectures available for managing the high availability of a PostgreSQL cluster, each with pros and cons. This document focuses on one of them — streaming replication. Download this white paper for deployment recommendations, as well as a technical overview, of a streaming replication solution that provides high availability for mixed-workload applications.