Chapter 12. Replication and Upgrades
In this chapter, we will cover the following recipes:
- Replication best practices
- Setting up file-based replication – deprecated
- Setting up streaming replication
- Setting up streaming replication security
- Hot Standby and read scalability
- Managing streaming replication
- Using repmgr
- Using Replication Slots
- Monitoring replication
- Performance and Synchronous Replication
- Delaying, pausing, and synchronizing replication
- Logical Replication
- Bi-Directional Replication
- Archiving transaction log data
- Upgrading – minor releases
- Major upgrades in-place
- Major upgrades online
Introduction
The software described in this chapter is evolving quickly each year. It is important to understand the release levels of the database servers you are targeting ...
Get PostgreSQL 9 Administration Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
