Troubleshooting in Postgres with pgCenter

Alexey Lesovsky

Data Egret

PostgreSQL DBA

Duration 45 min

Sometimes problems arise during Postgres operation, and the faster they are identified and resolved, the happier users eventually will be. pgCenter is a set of CLI powerful utilities for troubleshooting in the "here and now" mode. In the talk I will show how to use pgCenter for efficient troubleshooting, the directions in which to search, and how to respond to certain problems, in particular how to:

  • check if Postgres is in the normal state;
  • identify promptly the faulty clients and stop them;
  • reveal too heavy queries;
  • and other tips and tricks of pgCenter.

Slides →