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.

------------------------------------------------------------------------------
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