Re: pg_upgrade issue upgrading 10 -> 13

[Thomas Kellerer <shammat@xxxxxxx>]

Sean Brown schrieb am 01.10.2020 um 16:51:
> I’m having a little problem using pg_upgrade to move from 10 to 13,
> I’m assuming the issue is related to the removal of pg_pltemplate,
> but I can’t find anything related to how to handle it.
>
> pg_upgrade —check reports that the clusters are compatible, but the
> actual upgrade fails starting the new cluster with -
>
> ERROR: relation “pg_catalog.pg_pltemplate” does not exist STATEMENT:
> GRANT SELECT ON TABLE “pg_catalog"."pg_pltemplate” TO "appuser”;
>
> Is there a way to deal with this that doesn’t include dropping the
> source table?

Does revoking the privilege before running pg_upgrade help?

So in the v10 database:

  revoke select on pg_catalog.pg_pltemplate from appuser;