Re: The timezone oddities

On 02/04/2014 01:21 PM, Alvaro Herrera wrote:
> 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.
>
Having just read Alvaro's post and knowing I did not manually set the TZ
I checked my 9.3 installation. Interesting output.

toys=# show timezone;
TimeZone
----------
Navajo
(1 row)
toys=# \!date
Invalid command \!date. Try \? for help.
toys=# \! date
Tue Feb 4 13:26:03 MST 2014

toys=# select * from version();
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 9.3.1 on x86_64-unknown-linux-gnu, compiled by gcc
(GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)

Perhaps building from source does make a guess at TZ. I am not residing
in the Navaho national territory, but is that just Mountain time?