Skip to content

Instantly share code, notes, and snippets.

@pramsey
Last active February 10, 2022 22:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pramsey/2a38e2e2b4c20eea2a837f14f84082d9 to your computer and use it in GitHub Desktop.
Save pramsey/2a38e2e2b4c20eea2a837f14f84082d9 to your computer and use it in GitHub Desktop.
PostgreSQL Extension Upgrades

The current PostgreSQL handling of extension upgrads is "very clever". It allows extension authors to define a set of extension files of the the form extensionName--versionA--versionB.sql and the extension mechanism will figure out what extension files need to be applied in order to service an update command like:

ALTER EXTENSION extensionName UPDATE TO 'versionB';

The clever bit is that if your extension is currently at versionA and you want to update to versionC, the extension framework will figure out that it can get there by first applying extensionName--versionA--versionB.sql and then applying extensionName--versionB--versionC.sql. So, very magical.

However, for large projects the overhead of managing the version-level bulk install script and also tracking all changes in order to generate the incremental scripts, and keeping them all in sync was rather high. The PostGIS project already had mechanisms to build up the install SQL file, and built that file so it could be applied directly onto an existing install. Essentially the install SQL file was also the upgrade SQL file.

This makes building the upgrade files easy: you just name copes of the install SQL with the from/to version names. So you get.

postgis--2.4.5--2.4.6.sql

And so on...

And so on... and so on... and so on...

This is the first problem for a project like PostGIS. We release a lot of versions. We have 5 stable branches in support, and each of those generates a few patch releases. As releases pile up, the number of extension files in a system grows.

Here's the list of upgrade sources supported in the current working master.

https://github.com/postgis/postgis/blob/master/extensions/upgradeable_versions.mk

Worse, those duplicative files can (in the case of systems like Windows) be copies of the whole install SQL file, resulting in a very very large extensions directory.

Also, since multiple stable branches are being maintained, it's entirely possible for someone to install a new PostGIS version that does not support upgrading from their current version.

  • postgis-2.3.3 is released
  • postgis-2.4.1 is release with support for upgrading from 2.3.3
  • postgis-2.3.4 is released
  • user of 2.3.3 updates to 2.3.4, then attempts to update to 2.4.1, cannot do it

Some kind of glob support could clear things up a lot.

Imagine if the upgrade file postgis--2.3.*--2.3.7.sql could support all combinations of upgrades to 2.3.7? It would also be, in almost all cases, an empty file anyways.

Similarly, postgis--2.2.*--2.3.7.sql could either be the usual full SQL file as things currently work, or it could still be just the changes between the 2.2 branch and the 2.3 branch. But skipping all the minor variants would cause it to cover all old and upcoming releases from the 2.2 branch.

For an idea of the "current state", I enclose here at the bottom, just the list of extension scripts for the postgis extension that exist on my computer (there is also a full set for postgis_raster, postgis_topology, etc).

/opt/pgsql/14/share/extension/postgis--2.0.0--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.3.9--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.0--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.3.9--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.0--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.3.9--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.0--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.3.9--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.1--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.0--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.1--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.0--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.1--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.0--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.1--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.0--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.2--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.1--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.2--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.1--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.2--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.1--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.2--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.1--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.3--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.2--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.3--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.2--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.3--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.2--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.3--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.2--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.4--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.3--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.4--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.3--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.4--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.3--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.4--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.3--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.5--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.4--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.5--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.4--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.5--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.4--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.5--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.4--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.6--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.5--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.6--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.5--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.6--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.5--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.6--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.5--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.7--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.6--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.7--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.6--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.7--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.6--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.0.7--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.6--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.0--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.7--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.0--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.7--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.0--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.7--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.0--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.7--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.1--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.8--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.1--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.8--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.1--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.8--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.1--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.8--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.2--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.9--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.2--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.9--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.2--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.9--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.2--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.4.9--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.3--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.0--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.3--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.0--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.3--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.0--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.3--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.0--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.4--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.1--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.4--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.1--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.4--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.1--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.4--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.1--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.5--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.2--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.5--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.2--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.5--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.2--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.5--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.2--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.6--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.3--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.6--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.3--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.6--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.3--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.6--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.3--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.7--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.4--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.7--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.4--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.7--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.4--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.7--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.4--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.8--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.5--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.8--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.5--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.8--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.5--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.8--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.5--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.9--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.6dev--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.9--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.6dev--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.9--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--2.5.6dev--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.1.9--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.0--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.0--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.0--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.0--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.0--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.0--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.0--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.0--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.1--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.1--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.1--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.1--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.1--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.1--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.1--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.1--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.2--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.2--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.2--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.2--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.2--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.2--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.2--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.2--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.3--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.3--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.3--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.3--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.3--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.3--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.3--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.3--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.4--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.4--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.4--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.4--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.4--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.4--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.4--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.4--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.5--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.5--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.5dev--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.5--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.5dev--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.5--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.0.5dev--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.5--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.0--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.6--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.0--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.6--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.0--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.6--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.0--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.6--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.1--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.7--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.1--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.7--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.1--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.7--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.1--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.7--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.2--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.8--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.2--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.8--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.2--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.8--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.2--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.2.8--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.2dev--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.0--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.3--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.0--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.3--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.0--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.3--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.0--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.3--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.1--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.4--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.1--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.4--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.1--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.4--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.1--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.1.4--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.10--3.1.5dev.sql       /opt/pgsql/14/share/extension/postgis--3.1.5--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.10--3.2.0dev.sql       /opt/pgsql/14/share/extension/postgis--3.1.5dev--3.1.5devnext.sql
/opt/pgsql/14/share/extension/postgis--2.3.10--3.2.1dev.sql       /opt/pgsql/14/share/extension/postgis--3.1.5dev--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.10--3.3.0dev.sql       /opt/pgsql/14/share/extension/postgis--3.1.5dev--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.11--3.1.5dev.sql       /opt/pgsql/14/share/extension/postgis--3.1.5dev--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.11--3.2.0dev.sql       /opt/pgsql/14/share/extension/postgis--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.11--3.2.1dev.sql       /opt/pgsql/14/share/extension/postgis--3.1.5devnext--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.11--3.3.0dev.sql       /opt/pgsql/14/share/extension/postgis--3.1.6dev--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.2--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.2--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.2--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0alpha1--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.2--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0beta1--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.3--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0beta2--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.3--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0beta3--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.3--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0dev--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.3--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0dev--3.2.0devnext.sql
/opt/pgsql/14/share/extension/postgis--2.3.4--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.4--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0devnext--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.4--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.0rc1--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.4--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.1dev--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.5--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.1dev--3.2.1devnext.sql
/opt/pgsql/14/share/extension/postgis--2.3.5--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.1dev--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.5--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.5--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.2.1devnext--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.6--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--3.3.0dev--3.3.0devnext.sql
/opt/pgsql/14/share/extension/postgis--2.3.6--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.6--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--3.3.0devnext--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.6--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--ANY--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.7--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--ANY--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.7--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--ANY--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.7--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--ANY--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.7--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--unpackaged--3.1.5dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.8--3.1.5dev.sql        /opt/pgsql/14/share/extension/postgis--unpackaged--3.2.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.8--3.2.0dev.sql        /opt/pgsql/14/share/extension/postgis--unpackaged--3.2.1dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.8--3.2.1dev.sql        /opt/pgsql/14/share/extension/postgis--unpackaged--3.3.0dev.sql
/opt/pgsql/14/share/extension/postgis--2.3.8--3.3.0dev.sql        /opt/pgsql/14/share/extension/postgis--unpackaged.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment