Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6 - Mailing list pgsql-admin

From Don Seiler
Subject Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6
Date
Msg-id CAHJZqBC9h+kVLvTt4rkEbEHDjv-Jk6-w6GO3z_nEpKqdY3-66Q@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6  (Don Seiler <don@seiler.us>)
Responses Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6
List pgsql-admin
On Fri, Nov 17, 2017 at 10:31 AM, Don Seiler <don@seiler.us> wrote:
My working guess right now is that the older JDBC was ignoring that user.timezone parameter when the connection was made. Would be interested in finding out when change happened to confirm.

Looks like this was actually answered in that other thread:

> I ask because a look at the PG JDBC code shows this, which did not 
> show up until Sept 22, 2011. Not sure what release, but it looks like 
> 9.2+: 

> // Construct and send a startup packet. 
>             String[][] params = { 
>                                     { "user", user }, 
>                                     { "database", database }, 
>                                     { "client_encoding", "UTF8" }, 
>                                     { "DateStyle", "ISO" }, 
>                                     { "extra_float_digits", "2" }, 
>                                     { "TimeZone", 
> createPostgresTimeZone() },  

Looks like that is in ConnectionFactoryImpl.java but the current git repo history only goes back to 2015. But at this point I'm satisfied in knowing that upgrading from JDBC 9.1 to a newer JDBC introduced the change we see.

Thanks,
Don.

--
Don Seiler
www.seiler.us

pgsql-admin by date:

Previous
From: Don Seiler
Date:
Subject: Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6
Next
From: Don Seiler
Date:
Subject: Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6