Book

PostgreSQL 12 High Availability Cookbook

Database outages are costly and largely avoidable. That's why it's important to apply time-tested high availability techniques. This book will help you design and build an indestructible PostgreSQL 12 cluster that can remain online even in the direst circumstances. You will learn to monitor and automate your way to reassuring high availability.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

24h28m

Language

English

About Book

Who Is This Book For?

This book is for Postgres administrators and developers who are looking to build and maintain a highly reliable PostgreSQL cluster. Although knowledge of the new features of PostgreSQL 12 is not required, a basic understanding of PostgreSQL administration is expected.

Book content

chapters 24h28m total length

Architectural Considerations

Hardware Planning

Minimizing Downtime

Proxy and Pooling Resources

Troubleshooting

Monitoring

PostgreSQL Replication

Backup Management

High Availability with repmgr

High Availability with Patroni

Low-Level Server Mirroring

High Availability via Pacemaker

High Availability with Multi-Master Replication

Data Distribution

Zero-downtime Upgrades

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required