Ad Widget

Collapse

Upgraded server to 7.2.0, but "Database history tables use primary key" = No

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • DmitryDonskikh
    Junior Member
    • Nov 2023
    • 7

    #1

    Upgraded server to 7.2.0, but "Database history tables use primary key" = No

    Hello.
    I've upgraded my server from 7.0.6 to 7.2.0, it works OK (PostgreSQL 13), but then I've found in System information:
    Database history tables use primary key No
    I'm afraid it wasn't done earlier, when upgrading 5 to 6 or 6 to 7...

    Is there a way to add primary keys to current 7.2 database? To which tables?
    Docs mention 'history_upgrade_prepare.sql' script, but I do not have it within my installation.
    Or at least give me a hint where can I find relevant installation sql scripts, to compare/recreate database structure manually.
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2

    unpack it and you can find that script at ./zabbix-7.2.0/database/postgresql/option-patches/history_upgrade_prepare.sql '
    it just renames your existing tables and recreates new ones, so you could do what that upgrade page says, selecting from old table and inster to new one...

    Comment

    Working...