[ADMIN] FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2to 9.6

Поиск
Список
Период
Сортировка
От Don Seiler
Тема [ADMIN] FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2to 9.6
Дата
Msg-id CAHJZqBALD244nL_iSBvfr7rKCid-zhe61JYtgZEPSujrixHRzg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения
Good morning.


However what I'm looking to answer is why this wasn't fatal in 9.2? From that other thread, it seems like the change occurred in 9.3, and in the 9.3 release notes I see this:

Sync our copy of the timezone library with IANA release tzcode2017c (Tom Lane)
 
This fixes various issues; the only one likely to be user-visible is that the default DST rules for a POSIX-style zone name, if no posixrules file exists in the timezone data directory, now match current US law rather than what it was a dozen years ago.

Would this explain why the app server was able to connect with timezone='CST' (in my case) in 9.2 but not in 9.6? Our workaround was either to use CST6CDT or just not set it altogether (which is what we chose since we're always in US/Central).

For what it's worth this is on CentOS 6.

Don.
 
--
Don Seiler
www.seiler.us

В списке pgsql-admin по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: [ADMIN] Reaching out pgbouncer people, doespgbouncer-general@lists.pgfoundry.org work
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6