assistance migrating DB from 1.8 to 2.0

[kblackwell]

I've been tasked upgrading our zabbix install.

I'm having a bit of an issue moving the data from the postgres server.

On the old server
DB user: zabbix-server
postgres user: postgres9

New server per install instructions
DB user: zabbix
postgres user: postgres

I've set up a user called zabbix-server on the new user, assigned owner of zabbix DB is zabbix-server. changed over on all tables, but I'm getting this error.

Thanks in advance.