Pg_upgrade issue

From: abbas alizadeh <ramkly(at)yahoo(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Pg_upgrade issue
Date: 2022-11-01 03:53:53
Message-ID: C166C34F-FE55-4C06-A6B1-F86058106A2D@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message KK CHN 2022-11-01 05:55:27 WAL Replication query
Previous Message Scott Ribe 2022-10-31 17:19:14 Re: Duplicate data even with primary keys enabled