Re: Daylight Saving Time - Mailing list pgsql-ports

From Zdenek Kotala
Subject Re: Daylight Saving Time
Date
Msg-id 45C0EC93.1050005@sun.com
Whole thread Raw
In response to Re: Daylight Saving Time  (<Match.Grun@thomson.com>)
List pgsql-ports
Match.Grun@thomson.com wrote:

<snip>
> Apologies for the follwing questions. You will be flooded with
> these, so I may as well ask them now.
>
> 1) What is the process to get from source to binary?

See makefile in the src/timezone directory and zic.c in the same place.

> 2) What files need to be changed?

There are lot of changes. Most "dangerous" are changes in the hardlinks.
There are many of new TZ files hadlinked to e.g. London and some old
hardliked file has now own separate file.

> 3) Do we need to rebuild and update all files (including
>    executables and binaries?

I think, if you remove all old timezones and copy new version in the
correct directory (e.g. /usr/share/pgsql/timezone) it will work.

> 4) Would we need to shutdown server, install new timezone
>    files and restart server?

Yes, postgres keep one used timezone file in the memory.

> Note, even Sun could not answer all the questions with their
> java FAQ, which seemed to be pretty good. We are still
> waiting a response on that one.

A lot of answers are also on this page, but PG8.0 is not covered.

http://www.sun.com/bigadmin/hubs/dst/software/


    Zdenek

pgsql-ports by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiple Crashs on OSX Intel
Next
From: anthony herve
Date:
Subject: Failed to run initdb: 128!