I'm currently running into a problem on pgAdmin 4 where I am unable to use the PostGIS extension. I first tried running it this way through PGAdmin 4:
DROP EXTENSION IF EXISTS postgis CASCADE; CREATE EXTENSION postgis; SELECT postgis_full_version();
This gives me this result in messages tab:
ERROR: could not open extension control file "/Library/PostgreSQL/13/share/postgresql/extension/postgis.control": No such file or directory SQL state: 58P01
I looked in my 'library/PostgreSQL/13/share/postgresql/extensions' folder and I don't find postgis.control file. I have also downloaded postgres.app and I would have thought this would solve my problem but it still does not appear there.
What might I be able to do so that the extension appears in the extensions folder?