upgrade database failed

[schuurs]

Hello,

I am upgrading the zabbix server from version 1.6.9 to 1.8.13 and I am encountering the following issue when I want to upgrade the database.

According to the manual, I have to execute the following command:

$ ....../upgrades/dbpatches/1.8/postgresql/patch.sql

However, when executing this command, I receive the following message:

./patch.sql: line 1: syntax error near unexpected token `('
./patch.sql: line 1: `CREATE INDEX actions_1 ON actions (eventsource,status);'

Does someone know what could be wrong and how to solve it?

I have postgresql 8.4.6 installed.

[schuurs]

upgrade database failed [solved]

Sorry, I forgot to go to the postgresql environment.