RE: PostGIS / PostgreSQL v10 compatibility?

"Regina Obe" <[email protected]>
Newsgroups gmane.comp.gis.postgis
Message-ID <[email protected]>
> Greetings,
> 
> What is the highest version of PostGIS that can be used with PostgreSQL
v10?
> (The matrix only goes back to PostgreSQL v11.)  We're doing an upgrade
from
> v10 to v17, and we want to minimize the number of "hops" of
> PostGIS/PostgreSQL upgrading.  Thanks!=

PostGIS 3.2 as noted here -
https://postgis.net/docs/manual-3.2/postgis_installation.html#install_requir
ements

That said if you can get to any version of PostGIS 3+ that is sufficient for
a pg_upgrade.  No need to try to go micro by micro.

You can also go straight  from any 2+ if you symlink the newer postgis-3,
raster_postgis-3 with the old names postgis-2.whatever since the on disk
format hasn't changed since 2+ days.
This I discuss here -
https://www.bostongis.com/blog/index.php?/archives/278-Using-pg_upgrade-to-u
pgrade-PostgreSQL-9.6-PostGIS-2.4-to-PostgreSQL-15-3.3-on-Yum.html 
and I would suggest that approach to avoid dealing with dependency changes
of proj, geos, gdal, etc over the years. As those tend to cause upgrade
nightmares with dependency libs.

There is an issue with upgrading to PostGIS 3.5.0 which is detailed here

https://lists.osgeo.org/pipermail/postgis-users/2024-October/046544.html

Hope that helps,
Regina
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.