pg_upgrade issue upgrading 10 -> 13

From: Sean Brown <sean(dot)brown(at)saminds(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_upgrade issue upgrading 10 -> 13
Date: 2020-10-01 14:51:03
Message-ID: 918798A5-7ADF-4252-A2BF-E5639F45EC15@saminds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2020-10-01 15:28:53 Re: pg_upgrade issue upgrading 10 -> 13
Previous Message Alban Hertroys 2020-10-01 12:18:42 Betr: Re: FATAL: terminating connection due to administrator command