This is a translation of the original English documentation page. Help us make it better.

Sidebar

9 PostgreSQL plugin

Overview

This section lists parameters supported in the PostgreSQL Zabbix agent 2 plugin configuration file (postgres.conf). Note that:

  • The default values reflect process defaults, not the values in the shipped configuration files;
  • Zabbix supports configuration files only in UTF-8 encoding without BOM;
  • Comments starting with "#" are only supported at the beginning of the line.

Parameters

Parameter Mandatory Range Default Description
Plugins.Postgres.CallTimeout no 1-30 global timeout The maximum wait time in seconds for a request to be completed.
Plugins.Postgres.CustomQueriesPath no Full pathname of a directory containing .sql files with custom queries.
Disabled by default.
Example: /etc/zabbix/postgres/sql
Plugins.Postgres.Host no localhost IP address or DNS name of the host used for PostgreSQL.
Examples: localhost, 192.168.1.1
Plugins.Postgres.KeepAlive no 60-900 300 The maximum time of waiting (in seconds) before unused plugin connections are closed.
Plugins.Postgres.Port no 5432 A port to be used for PostgreSQL.
Plugins.Postgres.Sessions.<SessionName>.Database no postgres Database name of a named session.
<SessionName> - name of a session for using in item keys.
Plugins.Postgres.Sessions.<SessionName>.Password no Named session password.
<SessionName> - name of a session for using in item keys.
Plugins.Postgres.Sessions.<SessionName>.TLSCAFile no Full pathname of a file containing the top-level CA(s) certificates for peer certificate verification, used for encrypted communications between Zabbix agent 2 and monitored databases.
<SessionName> - name of a session for using in item keys.
Plugins.Postgres.Sessions.<SessionName>.TLSCertFile no Full pathname of a file containing the agent certificate or certificate chain, used for encrypted communications between Zabbix agent 2 and monitored databases.
<SessionName> - name of a session for using in item keys.
Plugins.Postgres.Sessions.<SessionName>.TLSConnect no Encryption type for communications between Zabbix agent 2 and monitored databases.
<SessionName> - name of a session for using in item keys.

Accepted values:
required - require TLS connection;
verify_ca - verify certificates;
verify_full - verify certificates and IP address.
Plugins.Postgres.Sessions.<SessionName>.TLSKeyFile no Full pathname of a file containing the database private key used for encrypted communications between Zabbix agent 2 and monitored databases.
<SessionName> - name of a session for using in item keys.
Plugins.Postgres.Sessions.<SessionName>.Uri no postgres Named session connection string for Oracle.
<SessionName> - name of a session for using in item keys.

Should not include embedded credentials (they will be ignored).
Must match the URI format.
Supported schemes are tcp and unix.
Examples: tcp://127.0.0.1:5432
localhost
Plugins.Postgres.Sessions.<SessionName>.User no Named session username.
<SessionName> - name of a session for using in item keys.
Plugins.Postgres.Timeout no 1-30 global timeout Request execution timeout (how long to wait for a request to complete before shutting it down).

See also: