Package: zabbix-server-pgsql Severity: normal X-Debbugs-Cc: [email protected]
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 -- System Information: Debian Release: 12.10 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 6.1.133-1-sunset-6-20250412-00 (SMP w/32 CPU threads; PREEMPT) Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE Locale: LANG=en_GB, LC_CTYPE=en_GB (charmap=ISO-8859-1), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages zabbix-server-pgsql depends on: ii adduser 3.134 ii fping 5.1-1 ii libc6 2.36-9+deb12u10 ii libcurl3-gnutls 7.88.1-10+deb12u12 ii libevent-2.1-7 2.1.12-stable-8 ii libgnutls30 3.7.9-2+deb12u4 ii libldap-2.5-0 2.5.13+dfsg-5 ii libodbc2 2.3.11-2+deb12u1 pn libopenipmi0 <none> ii libpcre2-8-0 10.42-1 ii libpq5 17.4-1.pgdg120+2 ii libsnmp40 5.9.3+dfsg-2 ii libssh2-1 1.10.0-3+b1 ii libxml2 2.9.14+dfsg-1.3~deb12u1 ii lsb-base 11.6 ii sysvinit-utils [lsb-base] 3.06-4 ii ucf 3.0043+nmu1+deb12u1 ii zlib1g 1:1.2.13.dfsg-1 Versions of packages zabbix-server-pgsql recommends: ii nmap 7.93+dfsg1-1 ii postgresql 15+248 pn snmpd <none> ii traceroute 1:2.1.2-1 Versions of packages zabbix-server-pgsql suggests: ii logrotate 3.21.0-1 pn snmp-mibs-downloader <none> ii sudo 1.9.13p3-1+deb12u1 pn zabbix-frontend-php <none>
