Re: The timezone oddities

Sergey Konoplev escribió:
> Hi,
>
> Gentoo Linux, PostgreSQL 9.2.4.
>
> I'm trying to find out why postgres uses a specific time zone that I
> don't expect to be used, and without any success so far. The situation
> seems strange to me, but I could probably miss something.

As far as I know, GMT is the fallback if no timezone is configured.  In
9.2 there's no longer a scan at postmaster start for a timezone matching
the system's; if you don't have a value set in postgresql.conf by
initdb, it will start as GMT.  This is a change from 9.1 behavior.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services