Skip site navigation (1) Skip section navigation (2)

Re: Upgrade question, going from 8.3 to 9.1...

From: Ned Wolpert <ned(dot)wolpert(at)gmail(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, Віталій Тимчишин <tivv00(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Upgrade question, going from 8.3 to 9.1...
Date: 2012-02-16 21:58:13
Message-ID: CAE7PAG3qLPVX9iHtC_OVkZxA9ArSmx1YiOKJP4cTpOJywKnWNQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
We have one query that uses postgis and it returns bytea stuff, so we'll
need to set
  bytea_output=escape
as default in our configuration file until the drivers are updated. But
sounds like that's the main issue for us.

Hopefully this will go easy. I haven't run into any problems yet, I'm now
going through the tuning we did for 8.3 and verifying what tuning makes
sense still, but I'm happy to see only a few small bumps in regards to the
JDBC driver.

Thanks


On Thu, Feb 16, 2012 at 2:06 PM, Kris Jurka <books(at)ejurka(dot)com> wrote:

>
>
> On Thu, 16 Feb 2012, Ned Wolpert wrote:
>
> > So, the driver issue was only in dealing with UNICODE issues? Is it true
> > that if we are always set with UNICODE client_encoding we should be fine?
> > (Or, another way to put it, we have already tested connection from the
> > existing java apps using the 8.3 driver to the new 9.1 database test
> > instance, and they worked 'just fine' for initial queries... is that
> where
> > this problem would manifest itself? Only in connecting?) Or was there
> > something else I missed in that thread?
>
> The end result of that thread was that the server folks ended up fixing
> the server to allow older JDBC clients to connect, so that was only an
> issue in the development version of the server for a short period of
> time, never in a released version.
>
> The big backwards compatibility change that occurred between 8.3 and 9.1
> servers was the bytea escaping option.  If you want to use an older driver
> you must set the bytea_output config option to escape on the server.
>
>
> http://www.postgresql.org/docs/9.1/static/runtime-config-client.html#GUC-BYTEA-OUTPUT
>
> Kris Jurka
>
>


-- 
Virtually, Ned Wolpert
http://codehead.tumblr.com/
http://codeheadsystems.wordpress.com/

"Settle thy studies, Faustus, and begin..."   --Marlowe

In response to

pgsql-jdbc by date

Next:From: Jason FreeDate: 2012-02-17 17:15:07
Subject: Driver 9.1 Connection does not have a registered XAResource
Previous:From: Kris JurkaDate: 2012-02-16 21:06:21
Subject: Re: Upgrade question, going from 8.3 to 9.1...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group