postgresql timezone and OS localtime correspondence - Mailing list pgsql-general

From Pavel Suderevsky
Subject postgresql timezone and OS localtime correspondence
Date
Msg-id CAEBTBzvXBnx9whGrby4Lv2GRb7e3bXSxoe1mPQpu=VSxsz=M6Q@mail.gmail.com
Whole thread Raw
Responses Re: postgresql timezone and OS localtime correspondence  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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? 

pgsql-general by date:

Previous
From: Bert
Date:
Subject: Re: [SQL] plan not correct?
Next
From: Igor Neyman
Date:
Subject: Re: Including SQL files