Hi. I've installed zabbix 3 "from packages": zabbix-server-postgre and zabbix-front-end.
Just after install I see that database "zabbix" do not exist.
I've created it manualy and given all privileges to new postgre user "zabbix".
Than i've downloaded sources and played schema, images and data sql files to the database.
On old zabbix 2.4 and pg 8.3 server I've dumped database:
pg_dump -U postgres -T history -T history_1 -T history_uint -T history_uint_1 -T trends_uint -T trends -T trends_uint_pkey -T alerts -T events -d zabbix -f dump.psql
On new server I've played: psql -f dump.psql -U zabbix.
But it seems something went wrong as I meet a lot of errors like:
And Frontend gives me errors on every page:
Just after install I see that database "zabbix" do not exist.
I've created it manualy and given all privileges to new postgre user "zabbix".
Than i've downloaded sources and played schema, images and data sql files to the database.
On old zabbix 2.4 and pg 8.3 server I've dumped database:
pg_dump -U postgres -T history -T history_1 -T history_uint -T history_uint_1 -T trends_uint -T trends -T trends_uint_pkey -T alerts -T events -d zabbix -f dump.psql
On new server I've played: psql -f dump.psql -U zabbix.
But it seems something went wrong as I meet a lot of errors like:
Code:
ERROR: constraint "c_trigger_depends_2" for relation "trigger_depends" already exists
Code:
pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "profiles_pkey" DETAIL: Key (profileid)=(5) already exists. [latest.php:829 → require_once() → CProfile::flush() → CProfile::insertDB() → DBexecute() → pg_query() in include/db.inc.php:518] Error in query [INSERT INTO profiles (profileid, userid, idx, value_str, type, idx2) VALUES (5, 1, 'web.menu.view.last', 'latest.php', 3, 0)] [ERROR: duplicate key value violates unique constraint "profiles_pkey" DETAIL: Key (profileid)=(5) already exists.] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [latest.php:829 → require_once() → CProfile::flush() → CProfile::insertDB() → DBexecute() → pg_query() in include/db.inc.php:518] Error in query [INSERT INTO profiles (profileid, userid, idx, value_str, type, idx2) VALUES (0, 1, 'web.paging.lastpage', 'latest.php', 3, 0)] [ERROR: current transaction is aborted, commands ignored until end of transaction block]