Book Image

PostgreSQL Replication, Second Edition

Book Image

PostgreSQL Replication, Second Edition

Overview of this book

Table of Contents (22 chapters)
PostgreSQL Replication Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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.