Message-ID: <269666903b69c2b9548fe75826174c14e103b818.camel@cybertec.at>
Subject: Re: Pg_upgrade issue
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: abbas alizadeh <ramkly@yahoo.com>, pgsql-admin
 <pgsql-admin@postgresql.org>
Date: Tue, 01 Nov 2022 07:43:51 +0100
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>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/269666903b69c2b9548fe75826174c14e103b818.camel%40cybertec.at>
Precedence: bulk

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