Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id ED7ED2E2FC2 for ; Thu, 6 Mar 2008 20:54:48 -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 17538-06-2 for ; Thu, 6 Mar 2008 20:54:46 -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 F047A2E2EB1 for ; Thu, 6 Mar 2008 20:54:37 -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 m270sTeZ027826; Thu, 6 Mar 2008 19:54:30 -0500 (EST) To: Shilpa Sudhakar cc: cat@zip.com.au, pgsql-admin@postgresql.org Subject: Re: Time Zone in Postgres In-reply-to: <47D089CE.4040607@internode.com.au> 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> Comments: In-reply-to Shilpa Sudhakar message dated "Fri, 07 Mar 2008 10:48:22 +1030" Date: Thu, 06 Mar 2008 19:54:29 -0500 Message-ID: <27825.1204851269@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/63 X-Sequence-Number: 28546 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