Learn to run PostgreSQL in production — configure streaming replication and read replicas, choose between synchronous and asynchronous commit, plan failover, pool connections with PgBouncer, partition large tables, and monitor the metrics that keep a cluster healthy. You finish able to design and operate a resilient, scalable PostgreSQL deployment.
Watch the free preview
How PostgreSQL replication works — WAL and standbys — free to watch, no account needed.
What you'll learn
- Run PostgreSQL in production with replication, pooling, partitioning and monitoring in place
- Configure physical streaming replication and read replicas from a primary
- Choose between synchronous and asynchronous replication for a given durability requirement
- Plan and execute a controlled failover, and pool connections with PgBouncer
- Partition large tables and monitor replication lag and other key cluster metrics
Syllabus
Streaming Replication Fundamentals
How PostgreSQL replication works — WAL and standbysFree preview
Building a streaming standby and read replicas
Durability and Failover
Synchronous versus asynchronous replication
Failover, promotion and high availability
Pooling and Partitioning
Connection pooling with PgBouncer
Partitioning large tables
Scaling and Monitoring
Vertical versus horizontal scaling
Monitoring the metrics that matter
Lab — 10 Exercises & Solutions
Exercises 1–5
Exercises 6–10