Just general remarks:
1. There is no need to upgrade to intermediate major versions. Go from 10.(lastest minor) directly to 16.3
2. Why would you want to upgrade to 15 when 16 is already out.
Regards,
Holger
Am 17. Juli 2024 15:24:04 MESZ schrieb SOzcn <selahattinozcnma@gmail.com>:
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" postgres
pg_restore: error: could not execute query: ERROR: relation "pg_catalog.pg_pltemplate" does not exist
Command 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
