Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 97E5E2E2E87 for ; Thu, 6 Mar 2008 21:00:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 24330-03 for ; Thu, 6 Mar 2008 21:00:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.internode.com.au (mail.internode.com.au [192.83.231.27]) by postgresql.org (Postfix) with ESMTP id 925792E2F17 for ; Thu, 6 Mar 2008 21:00:04 -0400 (AST) Received: from [172.16.0.221] (staffnet.internode.com.au [203.26.95.65]) by mail.internode.com.au (8.13.7/8.12.1) with ESMTP id m270xxhT021594; Fri, 7 Mar 2008 11:29:59 +1030 (CST) Message-ID: <47D09389.9030500@internode.com.au> Date: Fri, 07 Mar 2008 11:29:53 +1030 From: Shilpa Sudhakar User-Agent: Thunderbird 1.5.0.14 (Windows/20071210) MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: Time Zone in Postgres References: <2d6659d70803051856x652174a5ic8655d070a95db59@mail.gmail.com> <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> <27825.1204851269@sss.pgh.pa.us> In-Reply-To: <27825.1204851269@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.91.2, clamav-milter version 0.91.2 on mail X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/64 X-Sequence-Number: 28547 Hi Tom, I live in Adelaide Australia. I checked in 3 servers and all of them have "Australia/South" when i ran "show timezone" For the new timezone files, do i need to apply a timezone patch? Thanks Tom Lane wrote: > Shilpa Sudhakar writes: > >> 1) Checked the *postgresql.conf file* and the *timezone *parameter is >> set as "*unknown*". >> > > What does SHOW TIMEZONE report? Given the above, Postgres will try to > deduce what zone your operating system is using, but that doesn't always > work perfectly (especially if PG's timezone database isn't quite in sync > with the system's). If it guessed wrong, you might have to explicitly > set the appropriate zone in postgresql.conf. You weren't very clear > about where you live, so I don't know which of the numerous > Australia/wherever zones you should use... > > >> */local/pkgsrc/databases/postgresql80-pgcrypto/work/postgresql-8.0.9/src/timezone/data >> $ grep 2008 australasia* >> > > >> No results >> > > Well, no. 8.0.9 was released on 2006-10-16, many months before that > change in DST laws was passed. You need a newer set of zoneinfo files. > > regards, tom lane >