geog_brin_inclusion upgrade issue

lr at pcorp.us lr at pcorp.us
Sat Mar 15 17:20:14 PDT 2025


Justin,

We discussed this on PostGIS IRC, and decided it's better to provide a
standalone script to fix a broken brin install instead of trying to fold it
in.

Can you try installing this SQL script.

https://git.osgeo.org/gitea/postgis/postgis/raw/commit/890833a97846218562016
5645d368bf044b33fa7/utils/fix_brin.sql

Still a WIP and I haven't had a chance to try to break my postgis install to
fully test it.

Try running the above script on one of your databases that can't be
upgraded.

Then after, run

SELECT postgis_extensions_upgrade();



A cleaner would have been for us to do a CREATE IF NOT EXISTS, but sadly
PostgreSQL doesn't support that construct for operators and operator
classes.  Hopefully it will in the future.


Hopefully this works,
Regina



More information about the postgis-devel mailing list