PostGIS / PostgreSQL v10 compatibility?

[Regina Obe]

> 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