Hello,
I deleted all "hosts" from zabbix configuration by my fault . Thats also delete my historical data and trends from "latest data". I looked into postgres database - data is there untouched. So in zabbix code or database must be somewhere timestamp which represent date, from when are data displayed in "latest data" when I restore prevoius hosts. I'm trying to find where and correct my mistake, any idea? Thank you.
zabbix_server --v
Zabbix server v2.0.8 (revision 38017) (21 August 2013)
Compilation time: Aug 25 2013 11:52:02
select * from history order by clock asc limit 2;
itemid | clock | value | ns
--------+------------+---------+-----------
29256 | 1375997196 | 0.0000 | 262533398
29736 | 1375997196 | 0.0000 | 344085573
date -R --date="1970-01-01 1375997196 sec GMT"
Thu, 08 Aug 2013 23:26:36 +0200
select * from history order by clock desc limit 2;
itemid | clock | value | ns
--------+------------+-----------+-----------
43617 | 1383750657 | 0.4600 | 103251949
40317 | 1383750657 | 0.0000 | 102623506
date -R --date="1970-01-01 1383750657 sec GMT"
Wed, 06 Nov 2013 16:10:57 +0100
I deleted all "hosts" from zabbix configuration by my fault . Thats also delete my historical data and trends from "latest data". I looked into postgres database - data is there untouched. So in zabbix code or database must be somewhere timestamp which represent date, from when are data displayed in "latest data" when I restore prevoius hosts. I'm trying to find where and correct my mistake, any idea? Thank you.
zabbix_server --v
Zabbix server v2.0.8 (revision 38017) (21 August 2013)
Compilation time: Aug 25 2013 11:52:02
select * from history order by clock asc limit 2;
itemid | clock | value | ns
--------+------------+---------+-----------
29256 | 1375997196 | 0.0000 | 262533398
29736 | 1375997196 | 0.0000 | 344085573
date -R --date="1970-01-01 1375997196 sec GMT"
Thu, 08 Aug 2013 23:26:36 +0200
select * from history order by clock desc limit 2;
itemid | clock | value | ns
--------+------------+-----------+-----------
43617 | 1383750657 | 0.4600 | 103251949
40317 | 1383750657 | 0.0000 | 102623506
date -R --date="1970-01-01 1383750657 sec GMT"
Wed, 06 Nov 2013 16:10:57 +0100