Still get "PostgreSQL server is not available. Waiting 5 Seconds..." with 7.2.0alpha2

[milprog]

Hi all

I'm running zabbix dockerized (image tag zabbix/zabbix-server-pgsql:alpine-trunk) on Raspberry Pi 5. Recently updated to 7.2.0alpha2 - the changelog says that the supported PostgreSQL version now includes Version 17.

However, I still get the error "Postgresql server not available" documented in https://www.zabbix.com/forum/zabbix-...qsl-version-17 .

My setup uses a separate schema 'zabbix' and a search path that includes just this schema (not including the public schema as usual). No problem with my V16.4 database server.

When I use environment variables for defining username, password etc. and try to access the database using psql, it works just fine.

I'm using timescaledb 2.18.0-dev on my new postgresql 17 instance . The (working) PostgreSQL 16.4 server uses timescaledb 2.17.0-dev. Maybe I will have to export the timescaledb tables separately and reimport them again (I was using a simple pg_dump) - but I suspect that the problem lies elsewhere; the data seems to be filled in properly.

Any ideas?

Best regards
Marcel

The logs from docker say:

** Preparing Zabbix server
** Preparing database
** Using POSTGRES_USER variable from ENV
** Using POSTGRES_PASSWORD variable from secret file
********************
* DB_SERVER_HOST: 192.168.90.253
* DB_SERVER_PORT: 5432
* DB_SERVER_DBNAME: zabbix
* DB_SERVER_SCHEMA: zabbix
********************
**** PostgreSQL server is not available. Waiting 5 seconds...
**** PostgreSQL server is not available. Waiting 5 seconds...
**** PostgreSQL server is not available. Waiting 5 seconds...
**** PostgreSQL server is not available. Waiting 5 seconds...
**** PostgreSQL server is not available. Waiting 5 seconds...
**** PostgreSQL server is not available. Waiting 5 seconds...
(...snip...)

See below the situation when attached to the zabbix-server container (after having set PGPASSWORD, PGDATABASE and PGUSER):

e7333b545099:/var/lib/zabbix$ export PGHOST=192.168.90.253
e7333b545099:/var/lib/zabbix$ psql
psql (16.3, server 17.0)
WARNING: psql major version 16, server major version 17.
Some psql features might not work.
Type "help" for help.

zabbix=> \dt
List of relations
Schema | Name | Type | Owner
--------+----------------------------+-------+-------------
zabbix | acknowledges | table | zbx_usr_srv
zabbix | actions | table | zbx_usr_srv
zabbix | alerts | table | zbx_usr_srv
zabbix | auditlog | table | zbx_usr_srv
zabbix | autoreg_host | table | zbx_usr_srv
zabbix | changelog | table | zbx_usr_srv
zabbix | conditions | table | zbx_usr_srv
zabbix | config | table | zbx_usr_srv
zabbix | config_autoreg_tls | table | zbx_usr_srv
zabbix | connector | table | zbx_usr_srv
zabbix | connector_tag | table | zbx_usr_srv
zabbix | corr_condition | table | zbx_usr_srv
zabbix | corr_condition_group | table | zbx_usr_srv
zabbix | corr_condition_tag | table | zbx_usr_srv
zabbix | corr_condition_tagpair | table | zbx_usr_srv
zabbix | corr_condition_tagvalue | table | zbx_usr_srv
zabbix | corr_operation | table | zbx_usr_srv
zabbix | correlation | table | zbx_usr_srv
--More-- ^C
zabbix=> select * from dbversion;
dbversionid | mandatory | optional
-------------+-----------+----------
1 | 7010013 | 7010013
(1 row)
zabbix=> select * from history_uint limit 10;
itemid | clock | value | ns
--------+------------+------------+---------
47857 | 1726517797 | 8443543552 | 1007081
47859 | 1726517799 | 2574237696 | 1456465
47863 | 1726517803 | 1726517802 | 1053221
47871 | 1726517811 | 227806 | 1458060
47872 | 1726517812 | 9 | 1282014
47869 | 1726517809 | 3212820480 | 1584007
47874 | 1726517814 | 6179291136 | 1585750
47878 | 1726517818 | 1 | 1090822
47883 | 1726517823 | 380 | 1085084
47884 | 1726517824 | 0 | 1393867
(10 rows)

[milprog]

...meanwhile I rebuilt my pgsql17 container with timescaledb 2.17.1 (2.17 being the officially supported version), but the problem still persists. The zabbix server image has been updated as well (Server Zabbix 7.2.0alpha2 (revision 35faf08) .

[albertokg]

Hello,
I'm interested too.

Ciao