Re: Time Zone in Postgres

Hi Tom,

Thanks. I'll look into upgrading the database. Since we have a huge
bunch of databases i was thinking of an alternative for now.

As i said, we have version 8.2.4 databases and if i need to just update
the timezone files for this database do i copy the zoneinfo files from
the OS zonefile or from the newer version of Postgres zonefiles.

Thanks

Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>
>> Shilpa Sudhakar wrote:
>>
>>> 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.
>>>
>
>
>> FWIW this change is also in 8.1.11.
>>
>
> ... and 8.0.14 ...
>
> Anyway, yes, you could get the newer zoneinfo source files and run them
> through zic, but it's hard to see why that would be a smarter thing to
> do than a database update. There are known data-loss bugs in the minor
> version you're running, and you ought to be a lot more worried about
> those than about whether Postgres is a week off about the next DST
> transition.
>
> regards, tom lane
>