| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | abbas alizadeh <ramkly(at)yahoo(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Pg_upgrade issue |
| Date: | 2022-11-01 06:43:51 |
| Message-ID: | 269666903b69c2b9548fe75826174c14e103b818.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sacheen Birhade | 2022-11-01 06:44:10 | RE: [External] Re: WAL Replication query |
| Previous Message | Laurenz Albe | 2022-11-01 06:41:11 | Re: WAL Replication query |