Template DB PostgreSQL

[higi]

Hello,

i am trying to monitor PostgreSQL.
used this manual: https://www.zabbix.com/integrations/postgresql

not sure how to fully configure it on my VPS. I have connected zabbix agent and working. i can see linux cpu, ram usage etc.

i have two VPS (Debian) zabbix server and vps where is installed zabbix agent witch i want to minitor PSQL on it.


1. where should i put this password?
WITH PASSWORD '<PASSWORD>' INHERIT;

2. Copy postgresql/ to Zabbix agent home directory /var/lib/zabbix/. The postgresql/ directory contains the files needed to obtain metrics from PostgreSQL

should i copy whole /var/lib/postgresql/ to /var/lib/zabbix/ (in my case /usr/local/etc/postgresql zabbix_agentd.conf zabbix_agentd.conf.d zabbix_agentd.psk)
or should i link it somehow?

3." If PostgreSQL is installed from the PGDG repository, then add the path to pg_isready to the PATH environment variable for zabbix user. "
how can i do it? something like?
Edit the startup file (~/.bashrc)

1. Modify PATH variable
   PATH=/usr/local/etc/postgresql/bin:$PATH
   export PATH

i am still getting no data on PSQL
pls any help

[marcolussetti]

1. In the default setup here advised, it doesn't matter, because you're advised to rely on trust in pg_hba.conf, so no password is used for local connection (whether that's a wise idea on a production server is a different matter!)
2. The idea is to copy the contents of https://git.zabbix.com/projects/ZBX/...sql/postgresql to /var/lib/zabbix, not the local postgres installation
3. Can't find the wording in the upstream source, and unsure of the exact issue here.