pg_upgrade issue upgrading 10 -> 13 - Mailing list pgsql-general

From Sean Brown
Subject pg_upgrade issue upgrading 10 -> 13
Date
Msg-id 918798A5-7ADF-4252-A2BF-E5639F45EC15@saminds.com
Whole thread Raw
Responses Re: pg_upgrade issue upgrading 10 -> 13  (Thomas Kellerer <shammat@gmx.net>)
Re: pg_upgrade issue upgrading 10 -> 13  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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?


pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Betr: Re: FATAL: terminating connection due to administrator command
Next
From: Thomas Kellerer
Date:
Subject: Re: pg_upgrade issue upgrading 10 -> 13