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

From David G. Johnston
Subject Re: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
Date
Msg-id CAKFQuwZ7HDGErCWGnmb_NZHOBoL4GU4xkNeA-rswjtb8uiEXfA@mail.gmail.com
Whole thread Raw
In response to POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"  (Sérgio Duarte <duartes@gmail.com>)
Responses Re: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
List pgsql-bugs
On Thursday, March 26, 2026, Sérgio Duarte <duartes@gmail.com> wrote:
version
PostgreSQL 16.11 (Debian 16.11-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit

create extension if not exists postgis with schema sigop;

Query execution failed

Reason:
SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
  Detail: System catalog modifications are currently disallowed.

This seems more likely to be user-error than a bug.  At minimum you will need to specify the version of PostGIS you are installing in addition to the platform and server into which it is being installed.  I’m also pretty sure you don’t get to specify “with schema”.  You probably need to re-read the instructions for how to install PostGIS and follow them exactly.  That will likely result in an error-free installation.  If not, you probably should report any issues to them.  If they have an issue with the core server they can then report it here.

David J.

pgsql-bugs by date:

Previous
From: Sérgio Duarte
Date:
Subject: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
Next
From: Michael Paquier
Date:
Subject: Re: Segmentation fault in PostgreSQL 17.7 during REINDEX TABLE CONCURRENTLY