Ad Widget

Collapse

Migrating to Ubuntu

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • VDenis
    Junior Member
    • Dec 2013
    • 5

    #1

    Migrating to Ubuntu

    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:
    Code:
    ERROR:  constraint "c_trigger_depends_2" for relation "trigger_depends" already exists
    And Frontend gives me errors on every page:
    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]
Working...