Re: Time Zone in Postgres - Mailing list pgsql-admin

From Shilpa Sudhakar
Subject Re: Time Zone in Postgres
Date
Msg-id 47D09FA9.808@internode.com.au
Whole thread Raw
In response to Re: Time Zone in Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Time Zone in Postgres
List pgsql-admin
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@commandprompt.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
>


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Time Zone in Postgres
Next
From: Tom Lane
Date:
Subject: Re: Time Zone in Postgres