postgresql timezone and OS localtime correspondence

Поиск
Список
Период
Сортировка
От Pavel Suderevsky
Тема postgresql timezone and OS localtime correspondence
Дата
Msg-id CAEBTBzvXBnx9whGrby4Lv2GRb7e3bXSxoe1mPQpu=VSxsz=M6Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: postgresql timezone and OS localtime correspondence  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bert
Дата:
Сообщение: Re: [SQL] plan not correct?
Следующее
От: Igor Neyman
Дата:
Сообщение: Re: Including SQL files