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-Devel@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
>
------------------------------------------------------------------------------
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-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
