username\password in agent config file for Postgres monitoring?

[dangelsaurus]

reading https://www.zabbix.com/integrations/...#tabfficial2 it mentions ... "Set the user name and password in host macros ({$PG.USER} and {$PG.PASSWORD}) if you want to override parameters from the Zabbix agent configuration file."

And I'm curious how to go about setting the username\password in the zabbix_agent2.conf file so I'm not having to have them stored as macros on the zabbix server?

[dangelsaurus]

just wanting to bump to see if I might get some more eyes on this

[eithor]

Currently I have "workaround" that sets it in ~/.pgpass for the zabbix user on the host. (See postgres doc for syntax). For mysql/mariadb I have used db sessions, with config in zabbix agent like: "Plugins.Mysql.Sessions.db1.User=zbx_monitor" and then set URI/DSN macro to "db1" in zabbix.