Re: The timezone oddities - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: The timezone oddities
Date
Msg-id 20140204202152.GP10723@eldon.alvh.no-ip.org
Whole thread Raw
In response to The timezone oddities  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: The timezone oddities
List pgsql-general
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


pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: The timezone oddities
Next
From: Rob Sargent
Date:
Subject: Re: The timezone oddities