Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1759C9FAD5A for ; Wed, 31 Jan 2007 15:23:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 81365-08 for ; Wed, 31 Jan 2007 15:23:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gmp-ea-fw-1.sun.com (gmp-ea-fw-1.sun.com [192.18.1.36]) by postgresql.org (Postfix) with ESMTP id 4F1C99FA2C9 for ; Wed, 31 Jan 2007 15:23:29 -0400 (AST) Received: from d1-emea-09.sun.com ([192.18.2.119]) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id l0VJNSD4019509 for ; Wed, 31 Jan 2007 19:23:28 GMT Received: from conversion-daemon.d1-emea-09.sun.com by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JCQ00C01Z73P200@d1-emea-09.sun.com> (original mail from Zdenek.Kotala@Sun.COM) for pgsql-ports@postgresql.org; Wed, 31 Jan 2007 19:23:28 +0000 (GMT) Received: from [192.168.2.3] ([89.103.54.194]) by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JCQ003SMZ73UQZ2@d1-emea-09.sun.com>; Wed, 31 Jan 2007 19:23:28 +0000 (GMT) Date: Wed, 31 Jan 2007 20:22:59 +0100 From: Zdenek Kotala Subject: Re: Daylight Saving Time In-reply-to: <4AAF1740D046264BAD7CF21F81BADE5A03B1FD2E@tshuscodenmbx01.ERF.THOMSON.COM> To: Match.Grun@thomson.com Cc: pgsql-ports@postgresql.org Message-id: <45C0EC93.1050005@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7BIT References: <4AAF1740D046264BAD7CF21F81BADE5A03B1FD2E@tshuscodenmbx01.ERF.THOMSON.COM> User-Agent: Mail/News 1.5 (X11/20051211) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/15 X-Sequence-Number: 2523 Match.Grun@thomson.com wrote: > 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