Error: Upgrade 2.0.8 to 2.2.1 - proxy_autoreg_host

[edgdelgado]

Hi, Im having problems to upgrade my server.
CentOS 6.5

 ./configure --prefix=/opt/zabbix --mandir=/usr/share/man --enable-server --disable-static --disable-proxy --enable-agent --enable-ipv6 --with-postgresql --with-libcurl --with-net-snmp --with-ssh2 --with-openipmi --with-libxml2 --with-unixodbc

dependencies OK, no erros after ./configure or make install

when I start the server:

[---@--- tmp]# /etc/init.d/zabbix_server start
Starting zabbix_server:                                    [  OK  ]
[---@--- tmp]# tail -f zabbix_server.log
 12455:20140124:105309.237 SSH2 support:              YES
 12455:20140124:105309.237 IPv6 support:              YES
 12455:20140124:105309.237 ******************************
 12455:20140124:105309.237 using configuration file: /opt/zabbix/etc/zabbix_server.conf
 12455:20140124:105309.247 current database version (mandatory/optional): 02010000/02010000
 12455:20140124:105309.247 required mandatory version: 02020000
 12455:20140124:105309.248 starting automatic database upgrade
 12455:20140124:105309.248 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERRO:  must be the owner of relation proxy_autoreg_host
 [alter table proxy_autoreg_host alter id type bigint]
 12455:20140124:105309.248 database upgrade failed

Sugestions? table proxy_autoreg_host already OK witht the Ip type...

[edgdelgado]

Solved! my bad...

table owner was the postgres user and not the user I created for the Zabbix database... dunno why was like that