From: Tom Lane <tgl@sss.pgh.pa.us>
To: Shilpa Sudhakar <ssudhakar@internode.com.au>
Cc: cat@zip.com.au
Cc: pgsql-admin@postgresql.org
Subject: Re: Time Zone in Postgres
Date: Thu, 06 Mar 2008 19:54:29 -0500
Message-ID: <27825.1204851269@sss.pgh.pa.us> (raw)
In-Reply-To: <47D089CE.4040607@internode.com.au>
References: <2d6659d70803051856x652174a5ic8655d070a95db59@mail.gmail.com>
<BLU110-W2010012C95121A7D325BF9A9120@phx.gbl>
<2d6659d70803052151q5861981aw3a1a2e39e3970704@mail.gmail.com>
<BLU110-W581D897155BF62F438C486A9120@phx.gbl>
<19281.1204827832@sss.pgh.pa.us>
<47D076B3.8090304@internode.com.au>
<20080306234653.GA20591@bunyip.billabong.weebeasite.net>
<47D089CE.4040607@internode.com.au>
Shilpa Sudhakar <ssudhakar@internode.com.au> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, ssudhakar@internode.com.au, cat@zip.com.au
Subject: Re: Time Zone in Postgres
In-Reply-To: <27825.1204851269@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox