O'Reilly logo

PostgreSQL 9 Administration Cookbook - Second Edition by Simon Riggs, Gianni Ciolli, Hannu Krosing, Gabriele Bartolini

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required