Summary

In this chapter, you learned a lot about monitoring. We saw what to check for in the archive and how to interpret the PostgreSQL internal system views. Finally, we saw which processes to check for at the operating system level.

In general, it is recommended to use professional monitoring software, such as Zabbix, Nagios, and others, that is capable of running automated tests and issuing notifications.

All of these checks will, together, provide you with a pretty nice safety net for your database setup.

The next chapter is dedicated exclusively to High Availability. You will be taught the important concepts related to High Availability, and we will guide you through the fundamentals.

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.