[postgis-users] Postgis version for v10

[Regina Obe]

One other option if they really don't want to upgrade their 9.6 to 2.4.0alpha or you really don't want to provide 2.4.0alpha on 9.6.

I don't think we removed any functions in the .so/.dll files only added new ones.  So

1) You provide a PostGIS 2.4.0alpha for PostgreSQL 10
2) They make a copy of that .so file on PostgreSQL 10 and call the copy postgis-2.3.so
3) Then they should be able to pg_upgrade and after pg_upgrading immediately run on their new PostgreSQL 10 install.

ALTER EXTENSION postgis UPDATE; 

-----Original Message-----
From: Regina Obe [mailto:lr at pcorp.us] 
Sent: Monday, August 07, 2017 1:20 PM
To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
Subject: RE: [postgis-users] Postgis version for v10


> The history is here:

> https://bugzilla.redhat.com/show_bug.cgi?id=1055293


> So, here is the scenario:

> * There is a PostGIS 2.3 and Postgres 9.6 user, who want to upgrade to Postgres 10, and PostGIS 2.4.

> * To perform pg_upgrade, they need 2.3 so file as well in 2.4 installation (see bug report)

> * We fail here, as 2.3 cannot be built against v10.

> Regards, 

> --
> Devrim G nd z
> EnterpriseDB: https://www.enterprisedb.com PostgreSQL Danismani/Consultant, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR

Devrim,

We recently released PostGIS 2.4.0alpha - http://postgis.net/2017/08/05/postgis-2.4.0alpha/

Is it possible for you to:

1) Create a PostGIS 2.4.0alpha for PostgreSQL 9.6 and 10.0 then what they can do is
a) Do an ALTER EXTENSION postgis UPDATE on their PostgreSQL 9.6 to bring it up to 2.4.0alpha
b) Then do pg_upgrade to PostgreSQL 10 

We'll be having upgrade paths from postgis-2.4.0alpha, beta etc. to final when we release

Like I said, I'm hesitant to support 10 on 2.3, because we already ran into a lot of things we had to fix in 2.4. Because of the change in SRFs.
More things might crop up in release time and plus 2.4.0 has many more functions exposed as parallel aware so a better option for PostgreSQL 10 and 9.6 users (especially in 10 now that more strategies are available for parallel).

Thanks,
Regina