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_replicationsystem viewCheck 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 properly.