Zabbix agent 2 Postgres Plugin doesn't seem to allow setting the TLSConnect using Macros.  This is a problem as the default AWS RDS Postgres 15 instances now set rds.force_ssl on.  (The default for PGSQL 14 is disabled).

Agent logs show:

2023/05/30 15:19:49.614563 [PostgreSQL] Connection failed: failed to connect to `host=db.rds.amazonaws.com user=zabbixmonitoruser database=postgres`: server error (FATAL: no pg_hba.conf entry for host "10.85.1 │
│ 66.43", user "zabbixmonitoruser", database "postgres", no encryption (SQLSTATE 28000)).

It seems that I can set this via the postgresql.conf file using sessions, however the included template is not set to use sessions in any of the item Keys, which would mean creating a new version of the template for that.

Seems like any setting that you can set in the config file should be exposed via the UI as a macro as well.