postgis is missing the control files apparently:
=> create extension postgis;
ERROR: could not open extension control file "/usr/local/share/postgresql/extension/postgis.control": No such file or directory
This makes it kind of hard to use.
To which of the postgis ports does this PR apply?
databases/postgis21, the issue is the default is building without raster support, but raster support is needed to generate the extension control files and SQL.
Fix Summary and notify maintainer.
I'm discussing this with upstream now. For the moment, the quickest workaround is to enable RASTER support.
*** Bug 200707 has been marked as a duplicate of this bug. ***
This one's biting me too. Would be great to have the binary dist. working out of the box.
Per upstream's installation instructions at http://postgis.net/docs/postgis_installation.html#create_new_db_extensions, if PostGIS is built without RASTER enabled, you must enable spatial extensions using the following procedure:
createlang plpgsql yourdatabase
psql -d yourdatabase -f postgis.sql
psql -d yourdatabase -f postgis_comments.sql
psql -d yourdatabase -f spatial_ref_sys.sql
psql -d yourdatabase -f rtpostgis.sql
psql -d yourdatabase -f raster_comments.sql
psql -d yourdatabase -f topology.sql
psql -d yourdatabase -f topology_comments.sql
--if you built with sfcgal support --
psql -d yourdatabase -f sfcgal.sql
psql -d yourdatabase -f sfcgal_comments.sql
Is this still relevant?
Postgis21 is DEPRECATED, could be closed.
In fact, you have to install RASTER option to have control file on FreeBSD postgis23, 24 and 25 is correctly updated.
See Comment9, close with Overcome.