> 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
