installing zabbix-server-pgsql fails on initialising database

[Theo]

Binary package hint: zabbix-server-pgsql

Description: Ubuntu 8.04.1
Release: 8.04

Installing hardy zabbix-server-pgsql (1:1.4.2-4ubuntu3) fails with the following message

ERROR: syntax error at or near
"`" LINE 1: INSERT INTO `hosts` VALUES (10001,'Template_Linux','',0,'',1...

Details are also in /var/log/postgresql/postgresql-8.3-main.log

To manually correct the error do the following

cd /usr/share/zabbix-server
cp data.sql data-fixed.sql
# edit data-fixed.sql and remove all lines up to the blank line just before
# -- Dumping data for table `hosts`
# Ie. line 68
# Then remove all occurrences of the backtick (`) character surrounding any table
# names in the INSERT statements
# Save the file and load it into the zabbix database as follows

psql -h localhost -U zabbix -f data-fixed.sql zabbix

Several further warnings are generated which I have not had time to look at

-- Theo

PS - I selected continue after the error was reported from apt-get install...

[Fabián Rodríguez (magicfab)]

PLease be advised that Zabbix developers do not monitor this bug tracker, you may wish to also file a bug report upstream at
https://support.zabbix.com/