From: Murthy Nunna <mnunna@fnal.gov>
To: MichaelDBA Vitale <michaeldba@sqlexec.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: RE: pg_upgrade failure upgrading from v10.8 to v14.4
Date: Wed, 27 Jul 2022 11:48:55 +0000
Message-ID: <DM8PR09MB6677EA3ECD577B1C17DAB730B8979@DM8PR09MB6677.namprd09.prod.outlook.com> (raw)
In-Reply-To: <50242238.594620.1658511810130@email.ionos.com>
References: <DM8PR09MB667740FCD23BCFECA20E8A3CB8909@DM8PR09MB6677.namprd09.prod.outlook.com>
<CAKFQuwYKaU7eOpO2Z++TuDZX4GzVYmbgPpm0wdoRmW_O=FyGwQ@mail.gmail.com>
<1907988893.588756.1658509981368@email.ionos.com>
<DM8PR09MB6677FCDD0FD07ED0BDA0DFF4B8909@DM8PR09MB6677.namprd09.prod.outlook.com>
<CAKFQuwamnT7AQyk4oHRKObLs+2rWxZKc8WT96ExyQwuUXKMHKQ@mail.gmail.com>
<50242238.594620.1658511810130@email.ionos.com>
David and Michael,
Thank you both very much for your timely help!
From: MichaelDBA Vitale <michaeldba@sqlexec.com>
Sent: Friday, July 22, 2022 12:44 PM
To: David G. Johnston <david.g.johnston@gmail.com>; Murthy Nunna <mnunna@fnal.gov>
Cc: pgsql-admin@postgresql.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.g.johnston@gmail.com<mailto:david.g.johnston@gmail.com>> wrote:
On Fri, Jul 22, 2022 at 10:23 AM Murthy Nunna <mnunna@fnal.gov<mailto:mnunna@fnal.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mnunna@fnal.gov, michaeldba@sqlexec.com, david.g.johnston@gmail.com
Subject: RE: pg_upgrade failure upgrading from v10.8 to v14.4
In-Reply-To: <DM8PR09MB6677EA3ECD577B1C17DAB730B8979@DM8PR09MB6677.namprd09.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox