TIME ZONE is set to unknow in the conf file. The server syncs with NTP, has the correct time, but there is no TMZ env variable set. I set the recovery.conf to an hour before I want it and the logs show the time I wanted during DST. For example if I want a PITR of 9:55 AM, I put in 8:55 AM on the recovery.conf file, then the logs show a restore time of 9:55 AM was requested, and that's what gets processed. The non-DST part of the year, PITR works as expected and no adjustment is necessary.
> Date: Thu, 15 Jul 2010 14:34:11 -0500
> From: Kevin(dot)Grittner(at)wicourts(dot)gov
> To: bitsandbytes88(at)hotmail(dot)com; pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] tablespaces
>
> dx k9 <bitsandbytes88(at)hotmail(dot)com> wrote:
>
> > Has anyone noticed that doing a PITR during DST (March-November)
> > has the effect of being one ahead. Now I just adjust the
> > requested time an hour earlier, but is there a better way?
>
> I haven't noticed any odd behavior with PITR around Daylight Saving
> Time boundaries. Could you describe exactly how you have it set up
> and what you're seeing?
>
> -Kevin
_________________________________________________________________
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4