feat: support multiple versions of the postgis extension (#1667)
* feat: support multiple versions of the postgis extension
Build multiple versions of the postgis extension on different PostgreSQL versions.
Add test for the extensions and their upgrade on PostgreSQL 15 and 17.
* chore: correct formatting
* fix: symbolic linking removal
* chore: bump version to retest
* fix:
This fix ensures that the control files reference $libdir/$ext-$MIN_MAJ_VERSION (e.g., $libdir/postgis-3.3) which matches the actual library names built with the
--with-library-minor-version flag. This allows:
1. Multiple PostGIS versions to coexist (3.3.2 and 3.3.7 both use postgis-3.3.so)
2. Extensions to properly find their libraries during upgrades
3. The multi-version functionality to work correctly
* chore: bump to test
* fix: handling of versions
---------
Co-authored-by: Sam Rose <[email protected]>
