Zabbix Server not started on web interface - Ubuntu 20.04 and PostgreSQL

[jbrines]

Hi Guys,

When I look in the log file I get the following error

unable to start zabbix server due to unsupported postgresql database server version (12.9) must be at least (13.0)

How do I upgrade the database. I followed these instructions - to install - Download and install Zabbix 6.0 LTS for Ubuntu 20.04 (Focal), PostgreSQL, Apache

J.

[cyber]

By installing a correct version? Its not exactly a Zabbix question, how to install DB software on your server... PG should be present before you start with Zabbix install...
https://techviewleo.com/how-to-insta...ase-on-ubuntu/ for example...

[LT22]

I came accross the same problem and wanted to add some clarity/context about how I ended up with the same situation & question.

Steps to reproceduce:

1. Went to Download and install Zabbix 6.2 for Ubuntu 20.04 (Focal), PostgreSQL, Apache
2. Even clicked on the Documentation button and went to: 1 Database creation (zabbix.com)
3. Before running install commands I ran

   sudo apt install postgresql

4. Also ran sudo

   pg_ctlcluster 12 main start

5. Completed the rest of the steps.
6. Noticed message about unsupported postgesql version.

While cyber is correct it isn't a zabbix issue, all the steps from the above links were followed. However the answer is in the article he pasted.

For this guide, we are interested in the latest release version PostgreSQL 14 which is not provided by the default repositories and thus we will consider adding another repository.

Ubuntu 20.04 only has PostgreSQL 12.12 in their default repos (at time of writing)
Following the normal steps a regular Ubuntu user might eg:

sudo apt install postgresql

they would assume its installed and ready to go.
I only found out Zabbix needed 13~15 after doing extra reading of the system requirements once I hit the issue. It wasn't advised earlier in the process I went through after visiting zabbix.com

A way to avoid this in the future might for either of the first two links to mention when installing zabbinx 6 or 6.2 on Ubuntu 18 or 20 that you need to manually install a newer version of PostgreSQL than the one available by default.

Hope this helps someone

[LT22]

Oh also: Don't forget to remove postgresql12 before trying to install 14 if you want to keep things simple.

[cyber]

A way to avoid this in the future might for either of the first two links to mention when installing zabbinx 6 or 6.2 on Ubuntu 18 or 20 that you need to manually install a newer version of PostgreSQL than the one available by default.

There are always requirements... https://www.zabbix.com/documentation...n/requirements

PostgreSQL

13.0-15.X

Required if PostgreSQL is used as Zabbix backend database. PostgreSQL 15 is supported since Zabbix 6.2.4.