Re: The timezone oddities

[Rob Sargent <robjsargent@xxxxxxxxx>]

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?