Server is not running after PGSQL DB upgrade

[Aruzsi]

Hi,

On the WEB page:
System information: Parameter: Zabbix server is running Value: No 10051

Zabbix server is running! I can see the configurations (hosts, groups, etc.) but no new collected values!
The System information other Parameters are empty!

Ubuntu 20.04.6, Zabbix 5.0.32, Postgresql 12

I can't see any ERROR messages in the server or DB log.
Proxies was seen more than 24 minutes.

I tried to applying TimescaleDB.

Please help me!

TIA,
Ruzsi

[Aruzsi]

Maybe I found the root of this problem.

The server is connectiong to the DB. (In very simple: write)
The front-end is connecting to the DB, too. (read).

I thought the front-end is connecting to Zabbix server.

Because I have two Postgresql version with two Zabbix DB (dumped from version 10) and the Postgresql is running on different TCP ports (version 10 was the default 5432 and the newer 12 on TCP 5433.
I wanted to upgrade PSQL 10 -> 12 and I wanted the 12 is running on the default port (5432). I changed except the front-end config!!!
So Zabbix server is connected to the new DB on port 5432 and the front-end remained the other port (5433). So when I stopped PSQL 10 the front-end started to complain
about No database connection. The server was running happily on TCP 5432 PSQL 12.

It was a long time for me finding the solution.

TIA,