WRONG TIMESTAMP in postgresql

Martin Vit festr at wana.cz
Sun Oct 20 15:23:31 CEST 2002


hi i cannot find why i have bad time in postgre timestamp...

i'm using nagios 1.06b with postgresql 7.2 (redhat 6.2 with CEST time
(europe-prague UTC+2)

dump in table "servicestatus" (time is 15:18)

host1       UP      2002-10-20 11:19:36+02  2002-10-20 11:19:08+02
2002-10-19 11:38:12+02  0       80148   0
        0       1969-12-31 23:00:00+01  0       1       1       1       PING
OK - Packet loss = 0%, RTA = 13.35 ms      0
        1       0       0       1       1

status.cgi:
host1 PING WARNING 10-20-2002 11:17:55 0d 4h 0m 8s 2/3 PING WARNING - Packet
loss = 20%, RTA = 43.82 ms

so time is 4hours back in postgre, other timing is right (log, sheduling,
notification....)

anyone could help? or is it wrong inserting ?




-------------------------------------------------------
This sf.net email is sponsored by:
Access Your PC Securely with GoToMyPC. Try Free Now
https://www.gotomypc.com/s/OSND/DD




More information about the Users mailing list