From: abbas alizadeh <ramkly@yahoo.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Pg_upgrade issue
Date: Tue, 1 Nov 2022 07:53:53 +0400
Message-ID: <C166C34F-FE55-4C06-A6B1-F86058106A2D@yahoo.com> (raw)
References: <C166C34F-FE55-4C06-A6B1-F86058106A2D.ref@yahoo.com>
Hi experts
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?
Regards
Abbas
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: ramkly@yahoo.com
Subject: Re: Pg_upgrade issue
In-Reply-To: <C166C34F-FE55-4C06-A6B1-F86058106A2D@yahoo.com>
* 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