Re: [Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version
On Fri, Oct 12, 2012 at 5:18 PM, Justin Deoliveira jdeol...@opengeo.orgwrote: Ahh cool. Good to know. I will probably still parameterize the version at some point though so we can run unit tests against postgres 8 and 9 easily. Sounds like a good idea. In the past I've tried an upgrade a couple of times, but gave up because each attempt resulted in measurably lower performance (not that much of a slowdown, but back at the time there was no functional reason to do the upgrade). Cheers Andrea -- == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
Re: [Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version
Justin,
see also this Jira issue from February. If you upgrade the driver and
fix this failure, please resolve the issue:
Support PostgreSQL 9 hex bytea output format to avoid massive data
corruption
https://jira.codehaus.org/browse/GEOT-4040
Kind regards,
Ben.
On 12/10/12 21:08, Justin Deoliveira wrote:
I would use a property to make this configurable. Indeed I ran into this
same problem when trying to run postgis tests against a postgresql 9.1
database. The protocol for blobs has changed which caused those tests to
fail. Since we want to support both major versions of postgresql it
makes sense that this version is configurable.
Anyways, what you can do is this.
1. Define a property in the root pom, with the default being the current
postgresql jdbc driver version.
properties
postgresql.jdbc.version8.4-701.jdbc3/postgresql.jdbc.version
/properties
2. Update the dependency management entry.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
version${postgresql.jdbc.version}/version
/dependency
3. In imagemosaic-jdbc/pom.xml simply override the property.
properties
postgresql.jdbc.version9.1-901-1.jdbc4/postgresql.jdbc.version
/properties
-Justin
On Fri, Oct 12, 2012 at 2:57 AM, christian.muel...@nvoe.at
mailto:christian.muel...@nvoe.at wrote:
Long story for short. The postgis raster online test was broken and
the fix is to update the postgres driver version. The module will not
work with 8.x postgres drivers.
The global pom contains
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
version8.4-701.jdbc3/version
/dependency
The imagemosaic-jdbc pom has to specify its own version.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
!-- Overriding version number from parent POM. --
version9.1-901-1.jdbc4/version
scopetest/scope
/dependency
Perhaps we should update the version in the global POM ?.
Btw, our postgis jdbc driver is also not up to date.
Cheers
Christian
This message was sent using IMP, the Internet Messaging Program.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
mailto:GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Ben Caradoc-Davies ben.caradoc-dav...@csiro.au
Software Engineer
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
Re: [Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version
That is also in the Jira issue!
https://jira.codehaus.org/browse/GEOT-4040
If we upgrade the driver, do we fix it for everyone?
On 12/10/12 21:30, christian.muel...@nvoe.at wrote:
Hi Justin
I found another solution:
If you use a postgres driver lower than version 9 you can prepare your
database
with
ALTER DATABASE dbname SET bytea_output TO 'escape';
I will kick out myversion tag, prepare my test database and add
this info to the user guide. I think this is the cleanest solution.
Zitat von Justin Deoliveirajdeol...@opengeo.org:
I would use a property to make this configurable. Indeed I ran into this
same problem when trying to run postgis tests against a postgresql 9.1
database. The protocol for blobs has changed which caused those tests to
fail. Since we want to support both major versions of postgresql it makes
sense that this version is configurable.
Anyways, what you can do is this.
1. Define a property in the root pom, with the default being the current
postgresql jdbc driver version.
properties
postgresql.jdbc.version8.4-701.jdbc3/postgresql.jdbc.version
/properties
2. Update the dependency management entry.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
version${postgresql.jdbc.version}/version
/dependency
3. In imagemosaic-jdbc/pom.xml simply override the property.
properties
postgresql.jdbc.version9.1-901-1.jdbc4/postgresql.jdbc.version
/properties
-Justin
On Fri, Oct 12, 2012 at 2:57 AM,christian.muel...@nvoe.at wrote:
Long story for short. The postgis raster online test was broken and
the fix is to update the postgres driver version. The module will not
work with 8.x postgres drivers.
The global pom contains
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
version8.4-701.jdbc3/version
/dependency
The imagemosaic-jdbc pom has to specify its own version.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
!-- Overriding version number from parent POM. --
version9.1-901-1.jdbc4/version
scopetest/scope
/dependency
Perhaps we should update the version in the global POM ?.
Btw, our postgis jdbc driver is also not up to date.
Cheers
Christian
This message was sent using IMP, the Internet Messaging Program.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
This message was sent using IMP, the Internet Messaging Program.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
--
Ben Caradoc-Davies ben.caradoc-dav...@csiro.au
Software Engineer
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
[Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version
Long story for short. The postgis raster online test was broken and the fix is to update the postgres driver version. The module will not work with 8.x postgres drivers. The global pom contains dependency groupIdpostgresql/groupId artifactIdpostgresql/artifactId version8.4-701.jdbc3/version /dependency The imagemosaic-jdbc pom has to specify its own version. dependency groupIdpostgresql/groupId artifactIdpostgresql/artifactId !-- Overriding version number from parent POM. -- version9.1-901-1.jdbc4/version scopetest/scope /dependency Perhaps we should update the version in the global POM ?. Btw, our postgis jdbc driver is also not up to date. Cheers Christian This message was sent using IMP, the Internet Messaging Program. -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev ___ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
Re: [Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version
I would use a property to make this configurable. Indeed I ran into this
same problem when trying to run postgis tests against a postgresql 9.1
database. The protocol for blobs has changed which caused those tests to
fail. Since we want to support both major versions of postgresql it makes
sense that this version is configurable.
Anyways, what you can do is this.
1. Define a property in the root pom, with the default being the current
postgresql jdbc driver version.
properties
postgresql.jdbc.version8.4-701.jdbc3/postgresql.jdbc.version
/properties
2. Update the dependency management entry.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
version${postgresql.jdbc.version}/version
/dependency
3. In imagemosaic-jdbc/pom.xml simply override the property.
properties
postgresql.jdbc.version9.1-901-1.jdbc4/postgresql.jdbc.version
/properties
-Justin
On Fri, Oct 12, 2012 at 2:57 AM, christian.muel...@nvoe.at wrote:
Long story for short. The postgis raster online test was broken and
the fix is to update the postgres driver version. The module will not
work with 8.x postgres drivers.
The global pom contains
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
version8.4-701.jdbc3/version
/dependency
The imagemosaic-jdbc pom has to specify its own version.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
!-- Overriding version number from parent POM. --
version9.1-901-1.jdbc4/version
scopetest/scope
/dependency
Perhaps we should update the version in the global POM ?.
Btw, our postgis jdbc driver is also not up to date.
Cheers
Christian
This message was sent using IMP, the Internet Messaging Program.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
Re: [Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version
Hi Justin
I found another solution:
If you use a postgres driver lower than version 9 you can prepare your
database
with
ALTER DATABASE dbname SET bytea_output TO 'escape';
I will kick out my version tag, prepare my test database and add
this info to the user guide. I think this is the cleanest solution.
Zitat von Justin Deoliveira jdeol...@opengeo.org:
I would use a property to make this configurable. Indeed I ran into this
same problem when trying to run postgis tests against a postgresql 9.1
database. The protocol for blobs has changed which caused those tests to
fail. Since we want to support both major versions of postgresql it makes
sense that this version is configurable.
Anyways, what you can do is this.
1. Define a property in the root pom, with the default being the current
postgresql jdbc driver version.
properties
postgresql.jdbc.version8.4-701.jdbc3/postgresql.jdbc.version
/properties
2. Update the dependency management entry.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
version${postgresql.jdbc.version}/version
/dependency
3. In imagemosaic-jdbc/pom.xml simply override the property.
properties
postgresql.jdbc.version9.1-901-1.jdbc4/postgresql.jdbc.version
/properties
-Justin
On Fri, Oct 12, 2012 at 2:57 AM, christian.muel...@nvoe.at wrote:
Long story for short. The postgis raster online test was broken and
the fix is to update the postgres driver version. The module will not
work with 8.x postgres drivers.
The global pom contains
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
version8.4-701.jdbc3/version
/dependency
The imagemosaic-jdbc pom has to specify its own version.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/artifactId
!-- Overriding version number from parent POM. --
version9.1-901-1.jdbc4/version
scopetest/scope
/dependency
Perhaps we should update the version in the global POM ?.
Btw, our postgis jdbc driver is also not up to date.
Cheers
Christian
This message was sent using IMP, the Internet Messaging Program.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
This message was sent using IMP, the Internet Messaging Program.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
Re: [Geotools-devel] Postgis 2.0 raster and postgres jdbc driver version
Ahh cool. Good to know.
I will probably still parameterize the version at some point though so we
can run unit tests against postgres 8 and 9 easily.
-Justin
On Fri, Oct 12, 2012 at 7:30 AM, christian.muel...@nvoe.at wrote:
Hi Justin
I found another solution:
If you use a postgres driver lower than version 9 you can prepare your
database
with
ALTER DATABASE dbname SET bytea_output TO 'escape';
I will kick out my version tag, prepare my test database and add this
info to the user guide. I think this is the cleanest solution.
Zitat von Justin Deoliveira jdeol...@opengeo.org:
I would use a property to make this configurable. Indeed I ran into this
same problem when trying to run postgis tests against a postgresql 9.1
database. The protocol for blobs has changed which caused those tests to
fail. Since we want to support both major versions of postgresql it makes
sense that this version is configurable.
Anyways, what you can do is this.
1. Define a property in the root pom, with the default being the current
postgresql jdbc driver version.
properties
postgresql.jdbc.version8.4-**701.jdbc3/postgresql.jdbc.**version
/properties
2. Update the dependency management entry.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/**artifactId
version${postgresql.jdbc.**version}/version
/dependency
3. In imagemosaic-jdbc/pom.xml simply override the property.
properties
postgresql.jdbc.version9.1-**901-1.jdbc4/postgresql.jdbc.**version
/properties
-Justin
On Fri, Oct 12, 2012 at 2:57 AM, christian.muel...@nvoe.at wrote:
Long story for short. The postgis raster online test was broken and
the fix is to update the postgres driver version. The module will not
work with 8.x postgres drivers.
The global pom contains
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/**artifactId
version8.4-701.jdbc3/**version
/dependency
The imagemosaic-jdbc pom has to specify its own version.
dependency
groupIdpostgresql/groupId
artifactIdpostgresql/**artifactId
!-- Overriding version number from parent POM. --
version9.1-901-1.jdbc4/**version
scopetest/scope
/dependency
Perhaps we should update the version in the global POM ?.
Btw, our postgis jdbc driver is also not up to date.
Cheers
Christian
--**--**
This message was sent using IMP, the Internet Messaging Program.
--**--**
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-**dev2devhttp://p.sf.net/sfu/newrelic-dev2dev
__**_
GeoTools-Devel mailing list
GeoTools-Devel@lists.**sourceforge.netGeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/**lists/listinfo/geotools-develhttps://lists.sourceforge.net/lists/listinfo/geotools-devel
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--**--**
This message was sent using IMP, the Internet Messaging Program.
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
