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?
