Re: Time Zone in Postgres

Hi Tom,

I live in Adelaide Australia. I checked in 3 servers and all of them
have "Australia/South" when i ran "show timezone"

For the new timezone files, do i need to apply a timezone patch?

Thanks

Tom Lane wrote:
> Shilpa Sudhakar <ssudhakar(at)internode(dot)com(dot)au> writes:
>
>> 1) Checked the *postgresql.conf file* and the *timezone *parameter is
>> set as "*unknown*".
>>
>
> What does SHOW TIMEZONE report? Given the above, Postgres will try to
> deduce what zone your operating system is using, but that doesn't always
> work perfectly (especially if PG's timezone database isn't quite in sync
> with the system's). If it guessed wrong, you might have to explicitly
> set the appropriate zone in postgresql.conf. You weren't very clear
> about where you live, so I don't know which of the numerous
> Australia/wherever zones you should use...
>
>
>> */local/pkgsrc/databases/postgresql80-pgcrypto/work/postgresql-8.0.9/src/timezone/data
>> $ grep 2008 australasia*
>>
>
>
>> No results
>>
>
> Well, no. 8.0.9 was released on 2006-10-16, many months before that
> change in DST laws was passed. You need a newer set of zoneinfo files.
>
> regards, tom lane
>