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

Get PostgreSQL Administration Cookbook, 9.5/9.6 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.