[postgis-users] Postgis version for v10

Regina Obe lr at pcorp.us
Mon Aug 7 10:20:07 PDT 2017

> 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


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


More information about the postgis-users mailing list