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

From: Don Seiler <don(at)seiler(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6
Date: 2017-11-17 15:46:38
Message-ID: CAHJZqBCZeTHepEEnFFfQpyb=GngQKJPW=5QFVzDbDcSX8TxAQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Nov 17, 2017 at 9:43 AM, Don Seiler <don(at)seiler(dot)us> wrote:

> On Fri, Nov 17, 2017 at 9:36 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>
>>
>> I think what you need to be looking for is a
>> client-side change in how/when it sends a desired timezone setting to
>> the server.
>>
>
> given that everything else is the same, I have to believe something
> changed in how Postgres handles those connections in 9.3 and beyond.
>

I may have spoken too soon. We did upgrade the Postgres JDBC drivers on
that client app server yesterday, from 9.1-903 to 42.1.4 for Java 1.6.
Perhaps they changed something along the way there.

Don.

--
Don Seiler
www.seiler.us

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Craig James 2017-11-17 15:53:10 Replication with a third-party plug-in
Previous Message rammohan ganapavarapu 2017-11-17 15:43:57 Re: Can master and slave on different PG versions?