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

From Tom Lane
Subject Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6
Date
Msg-id 23393.1510932969@sss.pgh.pa.us
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  (Don Seiler <don@seiler.us>)
List pgsql-admin
Don Seiler <don@seiler.us> writes:
> The difference though is when the client sets that timezone when
> connecting, that's when the error is listed as FATAL and the connections
> fail in 9.6 (and also 9.3 according to the previous thread), where as the
> connections didn't fail in 9.2 and earlier. That's the behavior change I'm
> looking to account for.

Ah, gotcha.  I believe that the FATAL case occurs if the client tries
to set an invalid parameter value within the connection startup packet,
rather than after connecting.  But that behavior hasn't changed in
a long time either.  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.
        regards, tom lane


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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