Thanks, Dave. That is a good point. I think 8.2 came out in 2006 or so. Last release for 8.1 was in 2010.

Developers, are we happy to drop support for PostgreSQL below 8.2?

Kind regards,
Ben.

On 31/05/17 05:43, Dave Blasby wrote:
Hi, Ben,

Thanks for putting the PR together and making sure everything was tested
(esp online tests).

WRT postgresql version support, I found this in the release notes for
42.0.0;


   - Support for PostgreSQL versions below 8.2 was dropped


Thanks,
Dave

On Mon, May 29, 2017 at 8:31 PM, Ben Caradoc-Davies <b...@transient.nz>
wrote:

Dave,

with this upgrade, a full GeoTools build with online jdbc-postgis tests,
GeoServer build, community module compilation, and app-schema online tests
against postgis all pass. I also confirmed that the correct jar is included
in the assembled war and zip files.

Jira issue: https://osgeo-org.atlassian.net/browse/GEOT-5741
Pull request for master: https://github.com/geotools/geotools/pull/1605

Tested on debian unstable amd64:
postgresql-9.6 9.6.3-3 amd64
postgresql-9.6-postgis-2.3 2.3.1+dfsg-2 amd64

It would be good if someone could test this upgrade against an older
postgresql (especially 8).

$ mvn -version
Apache Maven 3.5.0 (ff8f5e7444045639af65f6095c62210b5713f426;
2017-04-04T07:39:06+12:00)
Maven home: /home/ben/java/maven
Java version: 1.8.0_131, vendor: Oracle Corporation
Java home: /usr/lib/jvm/java-8-openjdk-amd64/jre
Default locale: en_GB, platform encoding: UTF-8
OS name: "linux", version: "4.9.0-3-amd64", arch: "amd64", family: "unix"

Kind regards,
Ben.


On 30/05/17 09:22, Dave Blasby wrote:

Hi,

For GeoGig, we noticed that the latest Postgresql JDBC driver (42.1.1) now
allows full-binary data transfer.  This is better than 25% less bandwidth
than Base64 encoding!

I'd like to update the pom.xml  from 9.4.1211 to 42.1.1.

NOTE: PostGIS could be upgraded to use this as its a big win for a remote
(networked) database.
Note: you must use a prepared statement!


https://jdbc.postgresql.org/download.html

From the pom.xml;

<postgresql.jdbc.version>9.4.1211</postgresql.jdbc.version>

Comments?

Thanks,
Dave



------------------------------------------------------------
------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot



_______________________________________________
GeoTools-Devel mailing list
geotools-de...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel


--
Ben Caradoc-Davies <b...@transient.nz>
Director
Transient Software Limited <http://transient.nz/>
New Zealand



--
Ben Caradoc-Davies <b...@transient.nz>
Director
Transient Software Limited <http://transient.nz/>
New Zealand

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

Reply via email to