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?