PGConfRu2019 Alexey Lesovsky - «Troubleshooting in Postgres with pgCenter»
ฝัง
- เผยแพร่เมื่อ 27 พ.ย. 2019
- 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/2019/242775
#PGConfRu #PostgreSQL #Postgres #DBMS