Dan Langille napsal(a):
> Marek Simon wrote:
>> Hi,
>> I am currently solving some performance issues with my instance of 
>> bacula, so I need to see some statistics of recent jobs. But now I saw 
>> some jobs with negative duration (WTF!?) I zoom at them and I see all 
>> of them starts or end at 2009-10-25 between 2-3 am. Daylight saving 
>> time change. The postgres does the substraction OK, if the time zone 
>> is ok in the data, but I see the data type of the job.starttime and 
>> job.endtime is timestamp without time zone and probably of all 
>> timestamp data in bacula are without time zone as well!
>> It seems ok because servers usualy do not move between time zones, but 
>> in Europe does time zones move over the server twice a year (the 
>> daylight saving time change). And there could arise a big problem not 
>> only with job statistics but with retention times and of course with 
>> planning a schedule between 2-3 am.
>>
>> I consider that as bug and I am going to report it.
>> My version is 2.4.4 and I searched the documentation of version 3 and 
>> there is nothing abot time zone.
>>
>> Does anybody have got this problem too?
> 
> Probably, yes.
> 
> Retention times might be off by an hour.
> 
> Set your server to UTC.

UTC may help. But I need my schedules to fit with time when the people 
at my site sleep, not when the astronauts in ISS sleep. The program 
should take the time stamp from system with the time zone and store it 
with time zone, so calculating with it is allways correct because 
database function are correct about this. Now some jobs have a hour less 
and other have a hour more. How can I calculate an avarage duration?
I think the new version of bacula should work with all time with time 
zone and I am sure it would be not as difficult as it seems.

Marek


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users