Search Postgresql Archives

postgresql timezone and OS localtime correspondence

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

 



Hi,

My question is related to correspondence of postgresql "timezone" parameter with OS timezone settings in debian and red hat family systems.

In debian by default postgresql "timezone" parameter value is "localtime" and it succesfully gets current OS timezone. (most probably it is not dynamically updated and with changing OS timezone postgresql to be restarted likewise, but still)

In centos 7.2 postgresql doesn't accept "localtime" value and timezone must be specified directly. 

Mar 21 10:55:50 dbtest3.local pg_ctl[11242]: 2016-03-21 05:55:50 EST  LOG:  invalid value for parameter "TimeZone": "localtime"
[root@dbtest3 ~]# ls -la /etc/localtime                                      
lrwxrwxrwx. 1 root root 23 Mar 21 12:10 /etc/localtime -> /usr/share/zoneinfo/GMT

I couldn't find information related to difference between debian and red hat family systems for timezone parameter in docs.

So the common question is: is there a way to configure postgresql server to get OS localtime value rather than setting it manually in red hat family systems? 

[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