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