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