PGConfRu2019 Alexey Lesovsky - «Troubleshooting in Postgres with pgCenter»

Поделиться
HTML-код
  • Опубликовано: 10 сен 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

Комментарии •