Postgresql Monitoring using Zabbix

[Tek Chand]

Hello Team,

We want to monitor the postgresql using zabbix like active connections in DB, number of request we are getting per day etc. Can you please help me.

Thanks.

[Alex.S]

How's this: https://www.zabbix.com/integrations/postgresql

[Tek Chand]

Alex.S , Thank you for your response.

We are using Zabbix version 4.0.7 in production environment.

I setup a testing environment with Zabbix Version 4.0.14 and tried to use this template.

I have few question and issue when i tried it:

1. According to documentation in step 2 we need to copy /etc/postgresql whole directory in /var/lib/zabbix path?
2. When i import this template first i got error regarding zabbix version then i replace zabbix 4.2 with zabbix 4.0 in template xml file.
3. Then i tried again to import it and now getting below error:

```
Invalid tag "/zabbix_export/templates/template(1)": unexpected tag "tags".
```

Can you please give me link which is used for Zabbix Version 4.0.7? Or what changes are required here so it can work for us.

Thanks.

[Atsushi]

1.
Copy the postgresql directory in the files cloned from the following repositories under the /var/lib/zabbix directory.

https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/postgresql

In other words, SQL files such as pgsql.bgwriter.sql and pgsql.cache.hit.sql are placed under the /var/lib/zabbix/postgresql directory.

2.
This template has been tested with Zabbix 4.2.1 as described in README.md in the above repository, so if it is 4.0.7, it may not be imported as it is.

3.
Probably the information added in 4.2 is set and cannot be imported. If you rewrite part of the template XML, there is a possibility that it can be imported even in 4.0.7.

[Tek Chand]

Atsushi , Thank you for your response.

3.
Probably the information added in 4.2 is set and cannot be imported. If you rewrite part of the template XML, there is a possibility that it can be imported even in 4.0.7.

Yes..you are absolutely right here. After replacing the zabbix version from 4.2 to 4.0 i am getting below error when trying to import the template:

`Invalid tag "/zabbix_export/templates/template(1)": unexpected tag "tags".`

But i am unaware what changes are need to make in template to work it properly.

Can you please guide what changes are required in `.xml` file according to error?

Thanks.

[Tek Chand]

Atsushi , Can you please help me on above issue?

Thanks.

[Tek Chand]

Hello Atsushi,

Can you please help me?

Its become road block in my project.

Thanks.

[Atsushi]

It seems that it is not possible to solve it by correcting a little XML. I think it is a reliable method to build the environment of 4.4 separately and set the same setting to 4.0.