Re: Teach pg_upgrade to deal with invalid databases - Mailing list pgsql-hackers

From Bharath Rupireddy
Subject Re: Teach pg_upgrade to deal with invalid databases
Date
Msg-id CALj2ACUW1CTtW9dxVrNWbiqMZNP10nRKptjRCwGq0EXJPhpcwQ@mail.gmail.com
Whole thread
In response to Re: Teach pg_upgrade to deal with invalid databases  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
List pgsql-hackers
Hi,

On Tue, Sep 22, 2026 at 9:10 AM Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
>
> Even if core drops them automatically, having pg_upgrade deal with
> them is useful on its own IMHO, since the upgrade could start before
> that happens. So, I prefer pg_upgrade skipping them without any
> option, emitting info about the skipped ones, which will not happen
> often in practice once core handles the drop.

I implemented the above approach, pg_upgrade skipping them without any
option and emitting info about the skipped ones. I ensured the CI is
happy. Please find the attached v2 patch.

--
Bharath Rupireddy
Amazon Web Services: https://aws.amazon.com

Attachment

pgsql-hackers by date:

Previous
From: Dmitry Dolgov
Date:
Subject: Re: [PATCH] Add ALTER SYSTEM RELOAD
Next
From: Dmitry Fomin
Date:
Subject: Re: [PATCH v1 0/7] Wait event timing and tracing instrumentation