Re: Time Zone in Postgres

[Shilpa Sudhakar <ssudhakar(at)internode(dot)com(dot)au>]

Hi Tom,

If DST changes are done in version 8.2.5 and up, is there any way to 
recompile the timezone files in our existing versions without upgrading.

Thanks

Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>   
> > Shilpa Sudhakar wrote:
> >     
> > > From 2008, the DST ends on first Sunday of April and not on the last Sun 
> > > of March.
> > >       
>
>   
> > Please report this issue to the guys maintaining the TZ database
> > upstream:
> >     
>
> You sure they don't know about it already?
>
> # southeast Australia
> #
> # From Paul Eggert (2007-07-23):
> # Starting autumn 2008 Victoria, NSW, South Australia, Tasmania and the ACT
> # end DST the first Sunday in April and start DST the first Sunday in October.
> # http://www.theage.com.au/news/national/daylight-savings-to-span-six-months/2007/06/27/1182623966703.html
>
> This is in our releases 8.2.5 and up.  If the OP wants to live under a
> government that feels free to whack DST laws around on a couple months'
> notice, he's got to be prepared to keep up with software updates.
>
> 			regards, tom lane
>