#1103467 zabbix-server-pgsql: The zabbix database needs to be owned by the zabbix user

Package:
zabbix-server-pgsql
Source:
zabbix-server-pgsql
Description:
network monitoring solution - server (using PostgreSQL)
Submitter:
Lee Elliott
Date:
2025-04-17 21:21:02 UTC
Severity:
normal
#1103467#5
Date:
2025-04-17 21:17:40 UTC
From:
To:
Dear Maintainer,

the instructions for installing the zabbix-server-pgsql database in:

/usr/share/doc/zabbix-server-pgsql/README.Debian

tell you to 'su - postgres' before creating the zabbix db and the db zabbix user
but do not tell you to change the ownership of the zabbix db from 'postgres' to
'zabbix' before trying to create the database schema via the final zcat command.
If this is not done the zcat command fails with errors.

Altering the zabbix database to owner zabbix before running the zcat command allows
the database to be loaded without errors.

regards,

LeeE