Search Postgresql Archives

The timezone oddities

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 I found out.

1. There are no any per-database and no any per-user settings (the
\drds command shows both).

postgres=# \drds
No settings found.

2. There is nothing that changes the timezone from the system one in
postgresql.conf.

postgres@ip-xx ~ $ grep timezone
/db/postgresql/9.2/data/postgresql.conf
#log_timezone = unknown                 # actually, defaults to TZ environment
#timezone = unknown                     # actually, defaults to TZ environment
#timezone_abbreviations = 'Default'     # Select the set of available time zone

3. The system timezone is PST.

postgres@ip-xx ~ $ date
Tue Feb  4 10:31:51 PST 2014

4. No timezone is set as a command line parameter for the server.

postgres@ip-xx ~ $ grep PGOPTS /etc/conf.d/postgresql-9.2
#PGOPTS="-N 512 -B 1024"

postgres@ip-xx ~ $  ps aux | grep 'db/postgres'| grep -v grep
postgres 23561  0.0  0.6 18410880 445116 ?     S    Jan28   0:32
/usr/lib64/postgresql-9.2/bin/postgres -D /db/postgresql/9.2/data -D
/db/postgresql/9.2/data --data-directory=/db/postgresql/9.2/data

5. There is no env settings for PG* or TZ that might also affect
psql's behaviour.

postgres@ip-xx ~ $ env | grep PG
postgres@ip-xx ~ $ env | grep TZ

6. Therefore, the time zone is GMT.

postgres@ip-xx ~ $ psql
psql (9.2.4)
Type "help" for help.

postgres=# show timezone;
 TimeZone
----------
 GMT
(1 row)

Do you have any thoughts of where else this GMT could be set from?

Thank you in advance.

-- 
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@xxxxxxxxx


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux