Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-06-12 Thread Ben Caradoc-Davies 

Merged on master.

Kind regards,
Ben.

On 07/06/17 04:56, Andrea Aime wrote:

Hi,
I have no particular object, but not going to take responsibility for it.
Merge as you see fit
(and handle whatever side effect).

Cheers
Andrea

On Tue, Jun 6, 2017 at 6:54 PM, Dave Blasby 
wrote:


Hi,

I was hoping we could merge Ben's PR, which updates the driver version.

https://github.com/geotools/geotools/pull/1605

Thanks,
Dave

On Wed, May 31, 2017 at 4:08 AM, Ben Caradoc-Davies 
wrote:


CentOS 6 has 8.4.20:
http://mirror.centos.org/centos/6/os/x86_64/Packages/postgre
sql-8.4.20-7.el6.x86_64.rpm

CentOS 5 has 8.1.23, but CentOS 5 is past end of life:
http://vault.centos.org/5.11/os/x86_64/CentOS/postgresql-8.1
.23-10.el5_10.x86_64.rpm

Kind regards,
Ben.



On 31/05/17 20:17, Ian Turton wrote:


Looks like Centos go back to 8.0 but recommend 9.2 (
https://yum.postgresql.org/) so probably ok.

Ian

On 31 May 2017 at 09:12, Andrea Aime 
wrote:

Hi,

I don't know about CentOS, but though I'd look for the oldest supported
Ubuntu server, 12.04 [1], it seems it it was shipping with 8.4,
so good from this side

Cheers
Andrea

[1] Still supported only for paying customers but also provided as the
default choice on Azure

On Wed, May 31, 2017 at 9:46 AM, Ian Turton  wrote:




On 30 May 2017 at 23:29, Ben Caradoc-Davies  wrote:

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?



In general I'd say yes, may be best to check what Centos is shipping
with
currently as they are often far behind the curve

Ian



--
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





--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313 <+39%200584%20962313>
fax: +39 0584 1660272 <+39%200584%20166%200272>
mob: +39 339 8844549 <+39%20339%20884%204549>

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*


Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio
stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely
for
the attention and use of the named addressee(s) and may be confidential
or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure,
reproduction,
copying, distribution, or either dissemination, either whole or
partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy
or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---







--
Ben Caradoc-Davies 
Director
Transient Software Limited 
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-de...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel









--
Ben Caradoc-Davies 
Director
Transient Software Limited 
New Zealand

Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-06-06 Thread Andrea Aime 
Hi,
I have no particular object, but not going to take responsibility for it.
Merge as you see fit
(and handle whatever side effect).

Cheers
Andrea

On Tue, Jun 6, 2017 at 6:54 PM, Dave Blasby 
wrote:

> Hi,
>
> I was hoping we could merge Ben's PR, which updates the driver version.
>
> https://github.com/geotools/geotools/pull/1605
>
> Thanks,
> Dave
>
> On Wed, May 31, 2017 at 4:08 AM, Ben Caradoc-Davies 
> wrote:
>
>> CentOS 6 has 8.4.20:
>> http://mirror.centos.org/centos/6/os/x86_64/Packages/postgre
>> sql-8.4.20-7.el6.x86_64.rpm
>>
>> CentOS 5 has 8.1.23, but CentOS 5 is past end of life:
>> http://vault.centos.org/5.11/os/x86_64/CentOS/postgresql-8.1
>> .23-10.el5_10.x86_64.rpm
>>
>> Kind regards,
>> Ben.
>>
>>
>>
>> On 31/05/17 20:17, Ian Turton wrote:
>>
>>> Looks like Centos go back to 8.0 but recommend 9.2 (
>>> https://yum.postgresql.org/) so probably ok.
>>>
>>> Ian
>>>
>>> On 31 May 2017 at 09:12, Andrea Aime 
>>> wrote:
>>>
>>> Hi,
 I don't know about CentOS, but though I'd look for the oldest supported
 Ubuntu server, 12.04 [1], it seems it it was shipping with 8.4,
 so good from this side

 Cheers
 Andrea

 [1] Still supported only for paying customers but also provided as the
 default choice on Azure

 On Wed, May 31, 2017 at 9:46 AM, Ian Turton  wrote:


>
> On 30 May 2017 at 23:29, Ben Caradoc-Davies  wrote:
>
> 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?
>>
>>
> In general I'd say yes, may be best to check what Centos is shipping
> with
> currently as they are often far behind the curve
>
> Ian
>
>
> 
> --
> 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
>
>
>

 --
 ==
 GeoServer Professional Services from the experts! Visit
 http://goo.gl/it488V for more information.
 ==

 Ing. Andrea Aime
 @geowolf
 Technical Lead

 GeoSolutions S.A.S.
 Via di Montramito 3/A
 55054  Massarosa (LU)
 phone: +39 0584 962313 <+39%200584%20962313>
 fax: +39 0584 1660272 <+39%200584%20166%200272>
 mob: +39 339 8844549 <+39%20339%20884%204549>

 http://www.geo-solutions.it
 http://twitter.com/geosolutions_it

 *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*


 Le informazioni contenute in questo messaggio di posta elettronica e/o
 nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
 loro utilizzo è consentito esclusivamente al destinatario del messaggio,
 per le finalità indicate nel messaggio stesso. Qualora riceviate questo
 messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
 darcene notizia via e-mail e di procedere alla distruzione del messaggio
 stesso, cancellandolo dal Vostro sistema. Conservare il messaggio
 stesso,
 divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
 utilizzarlo per finalità diverse, costituisce comportamento contrario ai
 principi dettati dal D.Lgs. 196/2003.



 The information in this message and/or attachments, is intended solely
 for
 the attention and use of the named addressee(s) and may be confidential
 or
 proprietary in nature or covered by the provisions of privacy act
 (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
 Code).Any use not in accord with its purpose, any disclosure,
 reproduction,
 copying, distribution, or either dissemination, either whole or
 partial, is
 strictly forbidden except previous formal approval of the named
 addressee(s). If you are not the intended recipient, please contact
 immediately the sender by telephone, fax or e-mail and delete the
 information in this message that has been received in error. The sender
 does not give any warranty or accept liability as the content, accuracy
 or
 completeness of sent messages and accepts no responsibility  for changes
 made after they were sent or for other risks which arise as a result of
 e-mail transmission, viruses, etc.

 ---


>>>
>>>
>>>
>> --
>> Ben Caradoc-Davies 
>> Director
>> Transient Software Limited 
>> New Zealand
>>
>>

Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-06-06 Thread Dave Blasby 
Hi,

I was hoping we could merge Ben's PR, which updates the driver version.

https://github.com/geotools/geotools/pull/1605

Thanks,
Dave

On Wed, May 31, 2017 at 4:08 AM, Ben Caradoc-Davies 
wrote:

> CentOS 6 has 8.4.20:
> http://mirror.centos.org/centos/6/os/x86_64/Packages/postgre
> sql-8.4.20-7.el6.x86_64.rpm
>
> CentOS 5 has 8.1.23, but CentOS 5 is past end of life:
> http://vault.centos.org/5.11/os/x86_64/CentOS/postgresql-8.1
> .23-10.el5_10.x86_64.rpm
>
> Kind regards,
> Ben.
>
>
>
> On 31/05/17 20:17, Ian Turton wrote:
>
>> Looks like Centos go back to 8.0 but recommend 9.2 (
>> https://yum.postgresql.org/) so probably ok.
>>
>> Ian
>>
>> On 31 May 2017 at 09:12, Andrea Aime 
>> wrote:
>>
>> Hi,
>>> I don't know about CentOS, but though I'd look for the oldest supported
>>> Ubuntu server, 12.04 [1], it seems it it was shipping with 8.4,
>>> so good from this side
>>>
>>> Cheers
>>> Andrea
>>>
>>> [1] Still supported only for paying customers but also provided as the
>>> default choice on Azure
>>>
>>> On Wed, May 31, 2017 at 9:46 AM, Ian Turton  wrote:
>>>
>>>

 On 30 May 2017 at 23:29, Ben Caradoc-Davies  wrote:

 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?
>
>
 In general I'd say yes, may be best to check what Centos is shipping
 with
 currently as they are often far behind the curve

 Ian


 
 --
 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



>>>
>>> --
>>> ==
>>> GeoServer Professional Services from the experts! Visit
>>> http://goo.gl/it488V for more information.
>>> ==
>>>
>>> Ing. Andrea Aime
>>> @geowolf
>>> Technical Lead
>>>
>>> GeoSolutions S.A.S.
>>> Via di Montramito 3/A
>>> 55054  Massarosa (LU)
>>> phone: +39 0584 962313 <+39%200584%20962313>
>>> fax: +39 0584 1660272 <+39%200584%20166%200272>
>>> mob: +39 339 8844549 <+39%20339%20884%204549>
>>>
>>> http://www.geo-solutions.it
>>> http://twitter.com/geosolutions_it
>>>
>>> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>>>
>>>
>>> Le informazioni contenute in questo messaggio di posta elettronica e/o
>>> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
>>> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
>>> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
>>> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
>>> darcene notizia via e-mail e di procedere alla distruzione del messaggio
>>> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
>>> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
>>> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
>>> principi dettati dal D.Lgs. 196/2003.
>>>
>>>
>>>
>>> The information in this message and/or attachments, is intended solely
>>> for
>>> the attention and use of the named addressee(s) and may be confidential
>>> or
>>> proprietary in nature or covered by the provisions of privacy act
>>> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
>>> Code).Any use not in accord with its purpose, any disclosure,
>>> reproduction,
>>> copying, distribution, or either dissemination, either whole or partial,
>>> is
>>> strictly forbidden except previous formal approval of the named
>>> addressee(s). If you are not the intended recipient, please contact
>>> immediately the sender by telephone, fax or e-mail and delete the
>>> information in this message that has been received in error. The sender
>>> does not give any warranty or accept liability as the content, accuracy
>>> or
>>> completeness of sent messages and accepts no responsibility  for changes
>>> made after they were sent or for other risks which arise as a result of
>>> e-mail transmission, viruses, etc.
>>>
>>> ---
>>>
>>>
>>
>>
>>
> --
> Ben Caradoc-Davies 
> Director
> Transient Software Limited 
> 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-de...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>

Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-05-31 Thread Ben Caradoc-Davies 

CentOS 6 has 8.4.20:
http://mirror.centos.org/centos/6/os/x86_64/Packages/postgresql-8.4.20-7.el6.x86_64.rpm

CentOS 5 has 8.1.23, but CentOS 5 is past end of life:
http://vault.centos.org/5.11/os/x86_64/CentOS/postgresql-8.1.23-10.el5_10.x86_64.rpm

Kind regards,
Ben.


On 31/05/17 20:17, Ian Turton wrote:

Looks like Centos go back to 8.0 but recommend 9.2 (
https://yum.postgresql.org/) so probably ok.

Ian

On 31 May 2017 at 09:12, Andrea Aime  wrote:


Hi,
I don't know about CentOS, but though I'd look for the oldest supported
Ubuntu server, 12.04 [1], it seems it it was shipping with 8.4,
so good from this side

Cheers
Andrea

[1] Still supported only for paying customers but also provided as the
default choice on Azure

On Wed, May 31, 2017 at 9:46 AM, Ian Turton  wrote:




On 30 May 2017 at 23:29, Ben Caradoc-Davies  wrote:


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?



In general I'd say yes, may be best to check what Centos is shipping with
currently as they are often far behind the curve

Ian



--
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





--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313 <+39%200584%20962313>
fax: +39 0584 1660272 <+39%200584%20166%200272>
mob: +39  339 8844549 <+39%20339%20884%204549>

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---







--
Ben Caradoc-Davies 
Director
Transient Software Limited 
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

Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-05-31 Thread Ian Turton 
Looks like Centos go back to 8.0 but recommend 9.2 (
https://yum.postgresql.org/) so probably ok.

Ian

On 31 May 2017 at 09:12, Andrea Aime  wrote:

> Hi,
> I don't know about CentOS, but though I'd look for the oldest supported
> Ubuntu server, 12.04 [1], it seems it it was shipping with 8.4,
> so good from this side
>
> Cheers
> Andrea
>
> [1] Still supported only for paying customers but also provided as the
> default choice on Azure
>
> On Wed, May 31, 2017 at 9:46 AM, Ian Turton  wrote:
>
>>
>>
>> On 30 May 2017 at 23:29, Ben Caradoc-Davies  wrote:
>>
>>> 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?
>>>
>>
>> In general I'd say yes, may be best to check what Centos is shipping with
>> currently as they are often far behind the curve
>>
>> Ian
>>
>>
>> 
>> --
>> 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
>>
>>
>
>
> --
> ==
> GeoServer Professional Services from the experts! Visit
> http://goo.gl/it488V for more information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via di Montramito 3/A
> 55054  Massarosa (LU)
> phone: +39 0584 962313 <+39%200584%20962313>
> fax: +39 0584 1660272 <+39%200584%20166%200272>
> mob: +39  339 8844549 <+39%20339%20884%204549>
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>
> Le informazioni contenute in questo messaggio di posta elettronica e/o
> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
> darcene notizia via e-mail e di procedere alla distruzione del messaggio
> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
> principi dettati dal D.Lgs. 196/2003.
>
>
>
> The information in this message and/or attachments, is intended solely for
> the attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
> Code).Any use not in accord with its purpose, any disclosure, reproduction,
> copying, distribution, or either dissemination, either whole or partial, is
> strictly forbidden except previous formal approval of the named
> addressee(s). If you are not the intended recipient, please contact
> immediately the sender by telephone, fax or e-mail and delete the
> information in this message that has been received in error. The sender
> does not give any warranty or accept liability as the content, accuracy or
> completeness of sent messages and accepts no responsibility  for changes
> made after they were sent or for other risks which arise as a result of
> e-mail transmission, viruses, etc.
>
> ---
>



-- 
Ian Turton
--
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

Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-05-31 Thread Andrea Aime 
Hi,
I don't know about CentOS, but though I'd look for the oldest supported
Ubuntu server, 12.04 [1], it seems it it was shipping with 8.4,
so good from this side

Cheers
Andrea

[1] Still supported only for paying customers but also provided as the
default choice on Azure

On Wed, May 31, 2017 at 9:46 AM, Ian Turton  wrote:

>
>
> On 30 May 2017 at 23:29, Ben Caradoc-Davies  wrote:
>
>> 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?
>>
>
> In general I'd say yes, may be best to check what Centos is shipping with
> currently as they are often far behind the curve
>
> Ian
>
>
> 
> --
> 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
>
>


-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
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

Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-05-31 Thread Ian Turton 
On 30 May 2017 at 23:29, Ben Caradoc-Davies  wrote:

> 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?
>

In general I'd say yes, may be best to check what Centos is shipping with
currently as they are often far behind the curve

Ian
--
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

Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-05-30 Thread Ben Caradoc-Davies 
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 
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;



9.4.1211

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 
Director
Transient Software Limited 
New Zealand





--
Ben Caradoc-Davies 
Director
Transient Software Limited 
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

Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-05-30 Thread Dave Blasby 
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 
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;
>>>
>> 9.4.1211
>>
>> 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 
> Director
> Transient Software Limited 
> 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

Re: [Geoserver-devel] [Geotools-devel] upgrade postgresql JDBC driver to 42.1.1 (full binary xfer)

2017-05-29 Thread Ben Caradoc-Davies 

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;

9.4.1211

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 
Director
Transient Software Limited 
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