Add postgresql monitoring to zabbix (for anonymous statistics)

[Alexander Charykov]

We should monitor:

    process running
    postgresql version
    bytes received
    bytes send
    begin operations/s
    commit operatios/s
    delete operations/s
    insert operations/s
    rollback operations/s
    select operations/s
    update operations/s
    qps
    slow queries
    uptime
    relication status
    replication behind master

[Igor Shishkin (teran)]

https://share.zabbix.com/cat-db/db-postgresql

[Bogdan Dobrelya (bogdando)]

Set to incomplete as it is not clear should we track plugins' bugs in Fuel project scope or in Fuel plugins scope

[Alexander Charykov (acharykov)]

This bug doesn't belong to plugins, it is about infrastructure.

[Alexander Charykov (acharykov)]

Moving to 8.0 due to absence of time to fully implement this feature.

[Igor Shishkin (teran)]

In addition: currently I see some of items are using type 'zabbix trapper' which is not gonna work in our case.

[Oleg S. Gelbukh (gelbuhos)]

Is this bug still relevant? If not, let's change it to Won't Fix.

[sryabin (sryabin)]

Libzbxpgsql provides detailed and granular monitoring of PostgreSQL servers using a native Zabbix agent module.

Packages avialable here: https://sourceforge.net/projects/libzbxpgsl/files/

Devops documentation: http://cavaliercoder.com/libzbxpgsql/installation/

I can share my test environment, where zabbix_agent + libzbxpgsql already configured

[Bug Checker Bot (esikachev-l)]

(This check performed automatically)
Please, make sure that bug description contains the following sections filled in with the appropriate data related to the bug you are describing:

actual result

version

expected result

steps to reproduce

For more detailed information on the contents of each of the listed sections see https://wiki.openstack.org/wiki/Fuel/How_to_contribute#Here_is_how_you_file_a_bug

[Roman Prykhodchenko (romcheg)]

This bug has been incomplete for more than a month, please update its status or mark as an invalid one.

[Roman Prykhodchenko (romcheg)]

Marking as invalid.