password 'your_password'; After configuring the password, edit the file /etc/postgresql/*/main/pg_hba.conf to use scram-sha-256 authentication with the postgres user, allowed for the template1 database lines: listen_addresses = '*' wal_level = replica 427 Also edit the file /etc/postgresql/*/main/pg_hba.conf to add an extra line to allow the standby server connection for replication (that is a special

TO zbx_monitor;\\GRANT EXECUTE ON FUNCTION pg_catalog.pg_stat_file(text) TO zbx_monitor; Edit pg_hba.conf to allow connections from Zabbix agent (see PostgreSQL documentation for details). 474 Template agent configuration directory (/etc/zabbix/zabbix_agentd.d/) and restart Zabbix agent. 4. Edit pg_hba.conf to allow connections from Zabbix agent (see PostgreSQL documentation for details). Row examples: on ssl_min_protocol_version = 'TLSv1.3' ... For access control adjust /var/lib/pgsql/13/data/pg_hba.conf: 1507 ... ### require hostssl all all 0.0.0.0/0 md5 ### verify CA hostssl all all 0.0.0.0/0

TO zbx_monitor;\\GRANT EXECUTE ON FUNCTION pg_catalog.pg_stat_file(text) TO zbx_monitor; Edit pg_hba.conf to allow connections from Zabbix agent (see PostgreSQL documentation for details). 521 Template agent configuration directory (/etc/zabbix/zabbix_agentd.d/) and restart Zabbix agent. 4. Edit pg_hba.conf to allow connections from Zabbix agent (see PostgreSQL documentation for details). Row examples: on ssl_min_protocol_version = 'TLSv1.3' ... For access control adjust /var/lib/pgsql/13/data/pg_hba.conf: ... ### require hostssl all all 0.0.0.0/0 md5 ### verify CA hostssl all all 0.0.0.0/0 md5 clientcert=verify-ca

password 'your_password'; After configuring the password, edit the file /etc/postgresql/9.5/main/pg_hba.conf to use MD5 authentication with the postgres user: local all postgres

TO zbx_monitor;\\GRANT EXECUTE ON FUNCTION pg_catalog.pg_stat_file(text) TO zbx_monitor; Edit pg_hba.conf to allow connections from Zabbix agent (see PostgreSQL documentation for details). 492 Template agent configuration directory (/etc/zabbix/zabbix_agentd.d/) and restart Zabbix agent. 4. Edit pg_hba.conf to allow connections from Zabbix agent (see PostgreSQL documentation for details). Row examples: on ssl_min_protocol_version = 'TLSv1.3' ... For access control adjust /var/lib/pgsql/13/data/pg_hba.conf: ... ### require hostssl all all 0.0.0.0/0 md5 ### verify CA hostssl all all 0.0.0.0/0 md5 clientcert=verify-ca

on ssl_min_protocol_version = 'TLSv1.3' ... For access control adjust /var/lib/pgsql/13/data/pg_hba.conf: 25 ... ### require hostssl all all 0.0.0.0/0 md5 ### verify CA hostssl all all 0.0.0.0/0 md5 TO zbx_monitor;\\GRANT EXECUTE ON FUNCTION pg_catalog.pg_stat_file(text) TO zbx_monitor; Edit pg_hba.conf to allow connections from Zabbix agent (see PostgreSQL documentation for details). 955 Template agent configuration directory (/etc/zabbix/zabbix_agentd.d/) and restart Zabbix agent. 4. Edit pg_hba.conf to allow connections from Zabbix agent (see PostgreSQL documentation for details). Row examples:

ssl_prefer_server_ciphers = on ssl_min_protocol_version = 'TLSv1.3' ... 对于用户访问控制，请调整 /var/lib/pgsql/13/data/pg_hba.conf： ... ### require hostssl all all 0.0.0.0/0 md5 ### verify CA hostssl all all 0.0.0.0/0 md5 clientcert=verify-ca TO zbx_monitor;\\GRANT EXECUTE ON FUNCTION pg_catalog.pg_stat_file(text) TO zbx_monitor; 编 辑 pg_hba.conf 允 许 Zab- bix agent 连 接 访 问 (详 细 信 息 访 问PostgreSQL 文 档 查 看). 1168 模板名称强制性 宏添加步骤/说明 Template Zab- bix agent 配 置 目 录 (/etc/zabbix/zabbix_agentd.d/) and restart Zab- bix agent. 4. 编 辑 pg_hba.conf 允 许 从 Zab- bix agent 连 接 (访 问PostgreSQL 文 档查 看 更 多 详 情). 配 置 行 样 例: host all zbx_monitor 127

pg_ls_dir(text) TO zbx_monitor;\\GRANT EXECUTE ON FUNCTION pg_catalog.pg_stat_file(text) TO zbx_monitor; 编辑 pg_hba.conf 设置 Zabbix agent 白名单 (详情参 见PostgreSQL 文档). 433 模板名称 必配宏 附加步骤/注释 Redis {$REDIS.CONN.URI} - URI ql.conf 文件复制到 Zabbix agent 子配置文件目录中 (/etc/zabbix/zabbix_agentd.d/) 并重启 Zabbix agent. 4. 编辑 pg_hba.conf 为 Zabbix agent 设置白名单 (详 情参见 PostgreSQL 文档). 例子: host all zbx_monitor 127.0.0.1/32 trust host all ssl_prefer_server_ciphers = on ssl_min_protocol_version = 'TLSv1.3' ... /var/lib/pgsql/13/data/pg_hba.conf 配置文件用于访问控制的调整: ... ### require hostssl all all 0.0.0.0/0 md5 ### verify CA hostssl all all 0

PostgreSQL 时，您可能需要编辑 pg_hba.conf 文件以允许 zbx_monitor 用户的连接。如果双栈环境优先选择 IPv6（系统将 localhost 解析为 ::1），并且您配置了 localhost，但只添加了一个 IPv4 条目 (127.0.0.1/32)，那么连接将失败，因为没有匹配的 IPv6 条目。 以下 pg_hba.conf 文件示例确保 zbx_monitor ssl_prefer_server_ciphers = on ssl_min_protocol_version = 'TLSv1.3' ... /var/lib/pgsql/13/data/pg_hba.conf 配置文件用于访问控制的调整: ... ### require hostssl all all 0.0.0.0/0 md5 ### verify CA hostssl all all 0

configuration directory (/etc/zabbix/zabbix_agentd.d/) and restart Zabbix agent service. 4. Edit pg_hba.conf to allow connections from Zabbix agent (https://www.postgresql.org/docs/current/auth-pg-hba-conf