We have created template for postgresql database alert.like warnings errors now we received warnings errors but we haven’t recieved in our custom template (hostname) like database server details in email body.
Can you please share the entire template? If you make your own template, then that is all the data shown. Nothing else will be added. If you want server names, you need to add those variables to the template.
Okay thank you !! I had another question, how can I display the errors that appear in my postgresql database log file in these tools or how can I fire an email alert for that error?
If you want logs from your DB in PMM, you need to setup Loki, a plugin and side companion to Grafana. Here’s a blog that gives some guidance:
Since this is not officially supported, you’ll have to troubleshoot things on your own. You might end up having to create some custom alarms in PMM to trigger events from the logs in Loki.