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

From: MichaelDBA Vitale <michaeldba(at)sqlexec(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Murthy Nunna <mnunna(at)fnal(dot)gov>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_upgrade failure upgrading from v10.8 to v14.4
Date: 2022-07-22 17:43:30
Message-ID: 50242238.594620.1658511810130@email.ionos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
Hmmm, catalog views are in the pg_catalog schema, not the public schema.
</div>
<div class="default-style">
&nbsp;
</div>
<div class="default-style">
Only extensions or user-defined stuff would be created in the public schema.
</div>
<blockquote type="cite">
<div>
On 07/22/2022 1:26 PM EDT David G. Johnston &lt;david(dot)g(dot)johnston(at)gmail(dot)com&gt; wrote:
</div>
<div>
&nbsp;
</div>
<div>
&nbsp;
</div>
<div dir="ltr">
<div dir="ltr">
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: Arial,Helvetica,sans-serif;">On Fri, Jul 22, 2022 at 10:23 AM Murthy Nunna &lt;<a href="mailto:mnunna(at)fnal(dot)gov">mnunna(at)fnal(dot)gov</a>&gt; wrote:</span>
</div>
</div>
<div class="gmail_quote">
<blockquote>
<div style="overflow-wrap: break-word;">
<div class="gmail-m_-5348718172304268188WordSection1">
<p class="MsoNormal"><span style="font-size: 12pt;">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 12pt;">&nbsp;</span></p>
<p class="MsoNormal"><span style="font-size: 12pt;">CREATE VIEW "public"."all_tables" AS</span></p>
</div>
</div>
</blockquote>
<div>
&nbsp;
</div>
<div>
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
The system doesn't create stuff in public.&nbsp; That is user-space.
</div>
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
&nbsp;
</div>
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
David J.
</div>
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
&nbsp;
</div>
</div>
</div>
</div>
</blockquote>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.1 KB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nikhil Shetty 2022-07-22 19:00:54 Get hot_standby_feedback messages
Previous Message David G. Johnston 2022-07-22 17:26:10 Re: pg_upgrade failure upgrading from v10.8 to v14.4