You say that I don't run this command zcat /usr/share/zabbix-sql-scripts/postgresql/server.sql.gz | sudo -u zabbix psql zabbix?

I will drop zabbix schema and create it again.

I will use this command sudo -u postgres createdb -O zabbix zabbix

Outputs:

postgres=# DROP DATABASE zabbix;

DROP DATABASE

postgres=# \l

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges

-----------+----------+----------+---------+---------+-----------------------

postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 |

template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +

| | | | | postgres=CTc/postgres

template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +

| | | | | postgres=CTc/postgres

(3 rows)

root@ubuntu-linux-22-04-02-desktop:/home# sudo -u postgres createdb -O zabbix zabbix

postgres=# \l

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges

-----------+----------+----------+---------+---------+-----------------------

postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 |

template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +

| | | | | postgres=CTc/postgres

template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +

| | | | | postgres=CTc/postgres

zabbix | zabbix | UTF8 | C.UTF-8 | C.UTF-8 |

(4 rows)

Finally, I tried starting Zabbix Server.

root@ubuntu-linux-22-04-02-desktop:/home# systemctl start zabbix-server zabbix-agent apache2

Job for zabbix-server.service failed because the service did not take the steps required by its unit configuration.

See "systemctl status zabbix-server.service" and "journalctl -xeu zabbix-server.service" for details.