Connecting to PostgreSQL on Windows Server about libzbxpgsql HOT 2 CLOSED

It seems you are using Active Checks which means the Zabbix server expects the Windows agent to manage its own configuration, checks and submissions. In your case, the agent is not running the libzbxpgsql.so module so these items are not supported.

What you need to do, is change all of the item types from Zabbix agent (active) to Zabbix agent. This way the checks will be scheduled and executed on the Zabbix server which has libzbxpgsql.so loaded correctly.

from libzbxpgsql.

Hi Cavaliercoder,

Thanks for your quick answer! I was testing and I realized that I needed to configure my AGENT INTERFACE on Zabbix in HOST with the IP of the ZABBIX SERVER (since I installed the module libzbxpgsql.so loaded in it). Since I was using another template to monitor the SO, I had to do something different to adjust this.

In the PG SERVER HOST, it already have an AGENT INTERFACE with the IP of the server (to use SO template), so I've added the another AGENT INTERFACE with the IP of Zabbix Server, changed it to the DEFAULT and Updated the host.

Then, I've added the PostgreSQL Template, changing all the AGENT TYPE of the templates to ZABBIX AGENT (instead of ZABBIX AGENT (ACTIVE)), don't forget to change also the ITEMS on the DISCOVERY RULE. After it, change in the MACROS tab (also insed the Template) the parameter {$PG_CONN} = host=IP_PGSERVER port=PORT_PGSERVER user=USER_PGSERVER

After that, just add the template in the HOST and wait for the first discovery. It's working fine now! Also, don't forget to change in HOST the AGENT INTERFACE DEFAULT to the IP of the PostgreSQL server (just for new templates use the PG agent, not the Zabbix Server Agent).

I recommend to add some of this information on the WIKI so other people don't get confused (I got a lot confused when I was I could connect without installing the Agent on the PostgreSQL server but without information on how to do it.

Thank you very much for this module and for the help.

Regards,

Cristiano

from libzbxpgsql.