There is problem in table names used in data.sql , some data fails to import into PostgreSQL database. They should be "hosts" instead of `hosts`.

Following installation procedure with PGSQL fails:

sanatana# cat data.sql | psql -U zabbix zabbix
INSERT 404144 1
INSERT 404145 1
INSERT 404146 1
INSERT 404147 1
INSERT 404148 1
INSERT 404149 1
INSERT 404150 1
INSERT 404151 1
INSERT 404152 1
INSERT 404153 1
INSERT 404154 1
INSERT 404155 1
INSERT 404156 1
INSERT 404157 1
INSERT 404158 1
INSERT 404159 1
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10001,'Template_Linux','',0,'',1...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10002,'Template_Windows','',0,''...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10003,'Template_App_MySQL','',0,...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10004,'Template_Standalone','',0...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10007,'Template_SNMPv2_Device','...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10008,'Template_FreeBSD','Templa...

Can someone post fix?
Edit/Delete Message

http://www.zabbix.com/forum/showthread.php?t=7511