Error; pg_upgrade 10 to 15

From: SOzcn <selahattinozcnma(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Error; pg_upgrade 10 to 15
Date: 2024-07-17 13:24:04
Message-ID: CAJyV5Aabhb+99bkrz6tFLpm18bCBrFJxWGFT8DPNDnU-kCqoTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Folks,

We are upgrading from version 10 to 15. We encountered the following error
for the first time. Can you give any ideas on how to solve this error?
Since it is a system table, we cannot intervene on it.

*pg_restore: from TOC entry 3312; 0 0 ACL TABLE "pg_pltemplate"
postgrespg_restore: error: could not execute query: ERROR: relation
"pg_catalog.pg_pltemplate" does not existCommand was: GRANT SELECT ON TABLE
"pg_catalog"."pg_pltemplate" TO "username";*
We upgraded many Postgresql in the same way. But this error just blew up
somehow.
For this cluster, we upgraded 10 to 11 and then 11 to 12 without a problem,
but the same error comes after 12 to 13 and 12 to 15.

The other issue is that the check is successful when we check the cluster
for the upgrade.

The Upgrade Command;

/usr/lib/postgresql/15/bin/pg_upgrade
--old-bindir /usr/lib/postgresql/12/bin/
--new-bindir /usr/lib/postgresql/15/bin/
--old-datadir /data/rac/12/main/
--new-datadir /data/rac/15/main2
--old-options '-c config_file=/etc/postgresql/12/main/postgresql.conf'
--new-options '-c
config_file=/etc/postgresql/15/main2/postgresql.conf' --check

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Simpson 2024-07-17 13:24:43 Re: filesystem full during vacuum - space recovery issues
Previous Message James Pang 2024-07-17 09:34:58 logical decoding autovacuum changes