Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id ABBB02E007F for ; Thu, 6 Mar 2008 22:50:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 95365-01 for ; Thu, 6 Mar 2008 22:49:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F2B282E0048 for ; Thu, 6 Mar 2008 22:50:04 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m272nuqP002196; Thu, 6 Mar 2008 21:49:57 -0500 (EST) To: Shilpa Sudhakar cc: Alvaro Herrera , pgsql-admin@postgresql.org Subject: Re: Time Zone in Postgres In-reply-to: <47D09FA9.808@internode.com.au> References: <2d6659d70803052151q5861981aw3a1a2e39e3970704@mail.gmail.com> <19281.1204827832@sss.pgh.pa.us> <47D076B3.8090304@internode.com.au> <20080306234653.GA20591@bunyip.billabong.weebeasite.net> <47D089CE.4040607@internode.com.au> <20080307002740.GK1751@alvh.no-ip.org> <26884.1204850383@sss.pgh.pa.us> <47D09035.4020005@internode.com.au> <20080307010535.GM1751@alvh.no-ip.org> <29379.1204852863@sss.pgh.pa.us> <47D09FA9.808@internode.com.au> Comments: In-reply-to Shilpa Sudhakar message dated "Fri, 07 Mar 2008 12:21:37 +1030" Date: Thu, 06 Mar 2008 21:49:56 -0500 Message-ID: <2195.1204858196@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/69 X-Sequence-Number: 28552 Shilpa Sudhakar writes: > 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. If your platform uses the standard zoneinfo format (and if the file trees look similar, it probably does) then you could just copy the system's zoneinfo files into the Postgres directories, assuming you've gotten updated zoneinfo files for the system. regards, tom lane