Ad Widget

Collapse

manual update of values in items table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • joosep
    Junior Member
    • Sep 2019
    • 4

    #1

    manual update of values in items table

    Hi, I wanted to ask if there might be any issues with Zabbix if I manually update the items.history column values in database.
    We have at the moment more than 45K items where history='90d' and I need to set them to '30d'.
    My idea is to run this:

    Code:
    begin;
    update items set history = '30d' where history = '90d';
    commit;
    Has anyone done this kind of thing and lived to tell the tale?

    Database = postgres
    Zabbix version = 3.4.15

  • joosep
    Junior Member
    • Sep 2019
    • 4

    #2
    So should someone else have this question - after running some tests and then doing the actual updates in prod these kind of updates seem to be safe and have no ill side-effect.

    Comment

    Working...