PostgreSQL Whitepapers

The compilation of whitepapers presented below will help you develop a deeper knowledge about PostgreSQL and guide you through the tools and solutions provided by 2ndQuadrant. These technical documents highlight some of the common issues faced by day-to-day Postgres users and possible solutions to overcome them.

Highly Available Postgres Clusters

Highly Available Postgres Clusters

This whitepaper discusses the scenarios when designing a high availability architecture for PostgreSQL, including failover and switchover. It outlines strategies for backup and disaster recovery, and proposes an architecture that relies on best practices for high levels of reliability in production.

AlwaysOn Postgres

AlwaysOn Postgres

This whitepaper does a deep dive on how to achieve AlwaysOn Availability (up to 99.9999%). It gives an overview of the desirable features and benefits of delivering a very highly-available service. This architecture is based on the multi-master replication capabilities of BDR’s ground-breaking technology and also includes Rolling Upgrade abilities to ensure zero downtime.

BDR Whitepaper


This whitepaper gives an overview of BDR, including its use cases and deployment options, paying detailed attention to its features and benefits. BDR provides advanced replication, very high availability, scalability, and multi-master replication for PostgreSQL databases.

Security Best Practices

PostgreSQL Security Best Practices

This whitepaper documents well-proven PostgreSQL security best practices, giving an introduction to the fundamental concepts necessary for any cluster setup. Learn how to harden your PostgreSQL database cluster by developing a deeper understanding of the security features available and industry best practices. Learn More