Optimizing PostgreSQL on Red Hat OpenShift for High Availability

This white paper discusses the architecture for high availability and disaster recovery of PostgreSQL databases on Red Hat OpenShift, focusing on:

• Using multiple availability zones or subnets within a single OpenShift cluster for zero data loss and low recovery time objectives
• Isolating PostgreSQL workloads on dedicated nodes for better performance and resource management
• Utilizing PostgreSQL's native physical replication for synchronization
• Implementing continuous backup to object storage for point-in-time recovery with a maximum RPO of 5 minutes

The paper offers a reference architecture and best practices for deploying enterprise-grade PostgreSQL databases on OpenShift, leveraging EDB PG4K.