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_catalogto 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