Re: Error; pg_upgrade 10 to 15

On Wed, Jul 17, 2024 at 9:24 AM SOzcn <selahattinozcnma(at)gmail(dot)com> wrote:

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

https://www.postgresql.org/docs/12/catalog-pg-pltemplate.html

Looks like that table was removed after PG12:
https://www.postgresql.org/docs/release/13.0/
https://www.postgresql.org/docs/13/upgrading.html

Since the error was on the GRANT statement, REVOKE SELECT on that table and
the pg_upgrade should succeed.

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