Re: [GENERAL] The timezone oddities

2014-02-04 Thread Rob Sargent
On 02/04/2014 03:44 PM, Tom Lane wrote: Adrian Klaver writes: On 02/04/2014 12:31 PM, Rob Sargent wrote: 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? Yes: http://en.wikipedia.org/wiki/List_of_tz_datab

Re: [GENERAL] The timezone oddities

2014-02-04 Thread Tom Lane
Adrian Klaver writes: > On 02/04/2014 12:31 PM, Rob Sargent wrote: >> 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? > Yes: > http://en.wikipedia.org/wiki/List_of_tz_database_time_zones > The reason for

Re: [GENERAL] The timezone oddities

2014-02-04 Thread Adrian Klaver
On 02/04/2014 12:31 PM, Rob Sargent wrote: On 02/04/2014 01:21 PM, Alvaro Herrera wrote: 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? Yes: http://en.wikipedia.org/wiki/List_of_tz_database_time_zone

Re: [GENERAL] The timezone oddities

2014-02-04 Thread Sergey Konoplev
On Tue, Feb 4, 2014 at 12:41 PM, Adrian Klaver wrote: > On 02/04/2014 12:09 PM, Sergey Konoplev wrote: > So the postgresql.conf is the one created by initdb for this particular > installation? > > If that is the case it would seem that initdb could not determine what the > timezone is at init. I d

Re: [GENERAL] The timezone oddities

2014-02-04 Thread Adrian Klaver
On 02/04/2014 12:09 PM, Sergey Konoplev wrote: On Tue, Feb 4, 2014 at 11:29 AM, Adrian Klaver wrote: On 02/04/2014 11:23 AM, Sergey Konoplev wrote: 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 suc

Re: [GENERAL] The timezone oddities

2014-02-04 Thread Rob Sargent
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

Re: [GENERAL] The timezone oddities

2014-02-04 Thread Alvaro Herrera
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

Re: [GENERAL] The timezone oddities

2014-02-04 Thread Sergey Konoplev
On Tue, Feb 4, 2014 at 11:29 AM, Adrian Klaver wrote: > On 02/04/2014 11:23 AM, Sergey Konoplev wrote: >> 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 st

Re: [GENERAL] The timezone oddities

2014-02-04 Thread Adrian Klaver
On 02/04/2014 11:23 AM, Sergey Konoplev wrote: 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. Here is what