Re: [Major version upgrade] pg_upgrade fails despite passing check mode

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Abhishek Bhola <abhishek(dot)bhola(at)japannext(dot)co(dot)jp>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general(at)postgresql(dot)org
Subject: Re: [Major version upgrade] pg_upgrade fails despite passing check mode
Date: 2021-10-26 19:48:39
Message-ID: 20211026194839.GB12921@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 25, 2021 at 07:52:13AM +0900, Abhishek Bhola wrote:
> Thanks, let me try that out.
>
> But is there a way to know for sure if pg_upgrade will have any such problems?
> Other than FDW's owner, any other things I should check before upgrading other
> clusters?

No. pg_upgrade's check mode checks as much as it reasonable can, but it
doesn't try restoring the database schema, for performance reasons, and
that is where the failure is happening.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2021-10-26 20:01:33 Re: ZFS filesystem - supported ?
Previous Message Stephen Frost 2021-10-26 19:35:03 Re: ZFS filesystem - supported ?