[Bug 306240] [NEW] installing zabbix-server-pgsql fails on initialising database

[Theo]

Public bug reported:

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...

** Affects: zabbix (Ubuntu)
     Importance: Undecided
         Status: New

-- 
installing zabbix-server-pgsql fails on initialising database
https://bugs.launchpad.net/bugs/306240
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs at lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs