Modify zabbix template for postgresql ansible role

CentOS Infra issue/request

Please file this generic issue template or feel free to select another one in the list above (Description / Choose a template)

Issue Type

• [] Issue - problem with something that was working
• Feature Request - something you'd like us to add/modify/change
• [] Task - mostly used by CentOS Infra team for day-to-day operations or bigger plans

Description

As we recently had an issue about number of idle/active connections for kojihub/postgresql, this is a request to modify the zabbix template for postgresql role, and cover metrics like number of connections, etc. As max connections is itself an ansible variable, it can reused as zabbix macro and check active vs max and so trigger alerts on high usage, or applications not closing correctly db connections