Ad Widget

Collapse

Can't upgrade PostgreSQL database (3.4 to 4.0)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • NovaSatori
    Junior Member
    • Oct 2018
    • 13

    #1

    Can't upgrade PostgreSQL database (3.4 to 4.0)

    Hi, everyone!
    Trying to upgrade zabbix 3.4 to 4.0, get an error
    "query failed: [0] PGRES_FATAL_ERROR:ERROR: relation "groups_1" does not exist"
    If it matters, the database was migrated earlier from MySQL to PostgreSQL and worked fine. Any ideas?
  • NovaSatori
    Junior Member
    • Oct 2018
    • 13

    #2
    Ok, I manually created indexes for some tables. Not sure if it'is the right way to go, but at least database upgrade script has ended its job without errors.

    CREATE INDEX groups_1 ON groups (groupid);
    CREATE INDEX autoreg_host_1 ON autoreg_host (proxy_hostid,host);
    CREATE INDEX problem_tag_1 ON problem_tag (eventid,tag,value);
    CREATE INDEX problem_tag_2 ON problem_tag (eventid,tag,value);
    CREATE INDEX escalations_1 ON escalations (actionid, triggerid,itemid,escalationid);

    Comment

    Working...