Re: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump" - Mailing list pgsql-bugs

Thank you for your response and for pointing that out — I appreciate the guidance.

Here are the details of my environment:

• PostgreSQL version: 16.11
• Operating system: Debian 12 (bookworm)
• PostGIS version: 3.6.2 (installed via PGDG repository, package postgresql-16-postgis-3)

Initially, I attempted to install the extension using:

CREATE EXTENSION postgis WITH SCHEMA postgis;

However, I understand now that this may not be supported as PostGIS is not relocatable.

Using the standard command:

CREATE EXTENSION postgis;

worked successfully in the postgres database.

However, when attempting the same in another database (pg_prd), I encountered the following error:

ERROR: permission denied to create "pg_catalog.geometry_dump"
DETAIL: System catalog modifications are currently disallowed.

The current search_path for this database is:

public, "$user"

name	default_version	installed_version
postgis_sfcgal	3.6.2	[NULL]
postgis_raster-3	3.6.2	[NULL]
postgis_tiger_geocoder-3	3.6.2	[NULL]
postgis-3	3.6.2	[NULL]
postgis_tiger_geocoder	3.6.2	[NULL]
postgis_sfcgal-3	3.6.2	[NULL]
postgis	3.6.2	[NULL]
postgis_topology	3.6.2	[NULL]
postgis_topology-3	3.6.2	[NULL]
postgis_raster	3.6.2	[NULL]

If needed, I can provide additional diagnostic queries or outputs.

Thanks in advance for any help.