RE: pg_upgrade failure upgrading from v10.8 to v14.4

David and Michael,

Thank you both very much for your timely help!

From: MichaelDBA Vitale <michaeldba(at)sqlexec(dot)com>
Sent: Friday, July 22, 2022 12:44 PM
To: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>; Murthy Nunna <mnunna(at)fnal(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_upgrade failure upgrading from v10.8 to v14.4

Hmmm, catalog views are in the pg_catalog schema, not the public schema.

Only extensions or user-defined stuff would be created in the public schema.
On 07/22/2022 1:26 PM EDT David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com<mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:

On Fri, Jul 22, 2022 at 10:23 AM Murthy Nunna <mnunna(at)fnal(dot)gov<mailto:mnunna(at)fnal(dot)gov>> wrote:
I don’t think I am failing in a user created table. Looks like the failed view is one of the catalog views. Looks like I have to go to an intermediate version before getting to 14.4.

CREATE VIEW "public"."all_tables" AS

The system doesn't create stuff in public. That is user-space.

David J.