From: Laurenz Albe <laurenz.albe@cybertec.at>
To: abbas alizadeh <ramkly@yahoo.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Pg_upgrade issue
Date: Tue, 01 Nov 2022 07:43:51 +0100
Message-ID: <269666903b69c2b9548fe75826174c14e103b818.camel@cybertec.at> (raw)
In-Reply-To: <C166C34F-FE55-4C06-A6B1-F86058106A2D@yahoo.com>
References: <C166C34F-FE55-4C06-A6B1-F86058106A2D.ref@yahoo.com>
<C166C34F-FE55-4C06-A6B1-F86058106A2D@yahoo.com>
On Tue, 2022-11-01 at 07:53 +0400, abbas alizadeh wrote:
> I tried to upgrade one of my databases from v11 to v14.
> But I faced following error during upgrade:
> “System catalog modifications are currently disallowed”
> This is regarding to postgis extention that is installed in pg_catalog, apparently I can’t move extention from pg_catalog to public schema.
> In the other hand I can’t drop postgis extention as it uses frequently in different tables.
> Is there any option like “allow_system_table_mods” for pu_upgrade?
> Any idea how can I sort this issue?
Perhaps you can pre.install the extension is a proper schema on v14,
then dump and restore and ignore the error from CREATE EXTENSION.
Other than that, you would be reduced to fixing the old installation,
which would entail catalog modifications that might break your database.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
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: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, ramkly@yahoo.com
Subject: Re: Pg_upgrade issue
In-Reply-To: <269666903b69c2b9548fe75826174c14e103b818.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox