[root@localhost ~]# zabbix_agentd -t pgsql.connections.sum["localhost","5432","odoo","postgres"]
pgsql.connections.sum[localhost,5432,odoo,postgres] [t|{"active":1,"idle":4,"idle_in_transaction":0,"total":5,"total_pct":5,"waiting":0,"prepared":0}]


[root@localhost ~]# zabbix_get -s localhost -k pgsql.connections.sum["localhost","5432","odoo","postgres"]
/var/lib/zabbix/postgresql/pgsql.connections.sum.sql : Permission non accordée

[root@localhost ~]# zabbix_get --version
zabbix_get (Zabbix) 4.2.5
Revision 2c0e4d1d39 29 July 2019, compilation time: Jul 29 2019 15:51:30

Copyright (C) 2019 Zabbix SIA
License GPLv2+: GNU GPL version 2 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it according to
the license. There is NO WARRANTY, to the extent permitted by law.

This product includes software developed by the OpenSSL Project
for use in the OpenSSL Toolkit (http://www.openssl.org/).

Compiled with OpenSSL 1.0.1e-fips 11 Feb 2013
Running with OpenSSL 1.0.1e-fips 11 Feb 2013
[root@localhost ~]# zabbix_agentd --version
zabbix_agentd (daemon) (Zabbix) 4.2.5
Revision 2c0e4d1d39 29 July 2019, compilation time: Jul 29 2019 15:51:30

Copyright (C) 2019 Zabbix SIA
License GPLv2+: GNU GPL version 2 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it according to
the license. There is NO WARRANTY, to the extent permitted by law.

This product includes software developed by the OpenSSL Project
for use in the OpenSSL Toolkit (http://www.openssl.org/).

Compiled with OpenSSL 1.0.1e-fips 11 Feb 2013
Running with OpenSSL 1.0.1e-fips 11 Feb 2013

root@vpsXXXX:~# zabbix_server --version
zabbix_server (Zabbix) 4.2.5
Revision 2c0e4d1d39 29 July 2019, compilation time: Jul 29 2019 08:10:51

Copyright (C) 2019 Zabbix SIA
License GPLv2+: GNU GPL version 2 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it according to
the license. There is NO WARRANTY, to the extent permitted by law.

This product includes software developed by the OpenSSL Project
for use in the OpenSSL Toolkit (http://www.openssl.org/).

Compiled with OpenSSL 1.1.0f 25 May 2017
Running with OpenSSL 1.1.0k 28 May 2019

CentOS Linux release 7.6.1810 (Core)
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

CentOS Linux release 7.6.1810 (Core)
CentOS Linux release 7.6.1810 (Core)