PGConfRu2019 Alexey Lesovsky - «Troubleshooting in Postgres with pgCenter»
Вставка
- Опубліковано 19 вер 2024
- 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.
Alexey Lesovsky, Data Egret, PostgreSQL DBA
Talk page: pgconf.ru/en/2...
#PGConfRu #PostgreSQL #Postgres #DBMS