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

From: Don Seiler <don(at)seiler(dot)us>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6
Date: 2017-11-17 15:07:55
Message-ID: CAHJZqBALD244nL_iSBvfr7rKCid-zhe61JYtgZEPSujrixHRzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good morning.

My issue is more or less similar to
http://www.postgresql-archive.org/Upgrading-from-PG-8-3-3-to-9-3-4-FATAL-invalid-value-for-parameter-quot-TimeZone-quot-quot-PST-quot-td5805665.html

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-11-17 15:25:11 Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6
Previous Message Magnus Hagander 2017-11-17 15:01:03 Re: [ADMIN] Reaching out pgbouncer people, does pgbouncer-general@lists.pgfoundry.org work