public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Sérgio Duarte <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
Date: Thu, 26 Mar 2026 14:07:39 -0700
Message-ID: <CAKFQuwZ7HDGErCWGnmb_NZHOBoL4GU4xkNeA-rswjtb8uiEXfA@mail.gmail.com> (raw)
In-Reply-To: <CABYQJUR6xH1ERcV_7hrc13v+pVfjuURqx2hmqhp+No9ScWTOrw@mail.gmail.com>
References: <CABYQJUR6xH1ERcV_7hrc13v+pVfjuURqx2hmqhp+No9ScWTOrw@mail.gmail.com>
On Thursday, March 26, 2026, Sérgio Duarte <[email protected]> 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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
In-Reply-To: <CAKFQuwZ7HDGErCWGnmb_NZHOBoL4GU4xkNeA-rswjtb8uiEXfA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox