Troubleshooting PostgreSQL

In Chapter 11, Deciding on Useful Extensions, you learned about some useful extensions that are widely adopted and that can give your deployment a real boost. Following up, you will now be introduced to PostgreSQL troubleshooting. The idea is to give you a systematic approach to inspecting and fixing your system.

The following topics will be of interest:

  • Approaching an unknown database
  • Gaining a brief overview
  • Identifying the key bottlenecks
  • Handling storage corruption
  • Inspecting broken replicas

Keep in mind that many things can go wrong, so it is important to professionally monitor the database.

Get Mastering PostgreSQL 10 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.