Re: Timezone issues with Postrres

On Wed, Sep 21, 2011 at 3:16 AM, pratikchirania <pratik(dot)chirania(at)hp(dot)com> wrote:
> The command clearly does not return '--with-system-tzdata'. I am using
> Windows server 2008 R2. The TZ data must be working fine as other
> applications on the OS are working fine. The issue is also reproducible on
> Postgre version 8.3.

You said that your PostgreSQL time zone was set to UTC-6. Are you
sure that's the case? What's the output from 'SHOW timezone'? Also,
what's the system time zone set to?

The reason I ask is because, for me, setting the time zone to UTC-6
gives me a time that is six hours AHEAD of UTC, which wouldn't be
appropriate for South America:

rhaas=# select now() at time zone 'utc', now() at time zone 'utc -6';
timezone | timezone
----------------------------+----------------------------
2011-09-21 16:31:26.082048 | 2011-09-21 22:31:26.082048
(1 row)

The rules for interpreting time zone specifications are arcane enough
to make me suspect that this isn't a bug even though it seems rather
odd, but in any case it would be useful to know how many hours
PostgreSQL's timestamp is behind (or ahead of) UTC and similarly for
the operating system.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company