Chapter 6. Monitoring Your Setup

In previous chapters of this book, you learned about various kinds of replication and how to configure various types of scenarios. Now it's time to make your setup more reliable by adding monitoring. Monitoring is a key component of every critical system, and therefore a deep and thorough understanding of it is essential in order to keep your database system up and running.

In this chapter, you will learn what to monitor and how to implement reasonable monitoring policies. You will learn how to do the following:

  • Check your XLOG archive
  • Check the pg_stat_replication system view
  • Check for replication-related processes at the OS level

At the end of this chapter, you should be able to monitor any kind of replication setup ...

Get PostgreSQL Replication - 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.

Start your free trial