Ad Widget

Collapse

Trigger for a PostgreSQL database being dropped

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dusanj
    Junior Member
    • Jan 2023
    • 3

    #1

    Trigger for a PostgreSQL database being dropped

    Hello everyone. I am unable to find anything regarding my problem anywhere, not even the AI seems to be helpful... My issue is with PostgreSQL monitoring. It all works well, when a database is created on the host, Zabbix discovers it and starts monitoring it, up to here it's all good. However when I drop the database, Zabbix does not report any problem. It only shows an error message at the items linked to the dropped database (Preprocessing failed for: { "null" : {"datname":null,"numbackends":0,"xact_commit":0 ,"x act_rollback":0,"blks_read":29,"blks...
    1. Failed: cannot extract value from json by path "$['utelleru'].numbackends": no data matches the specified path​).
    What I need is a trigger that would go off when a previously discovered database goes "missing" all of a sudden.
    Maybe I'm just using the wrong keywords when looking for a solution, but I really can't find one and I would be very grateful if anyone could help me with this. Thanks in advance.
Working...