Re: [PATCH] pg_upgrade: add --initdb option to create the new cluster automatically

From: Bohyun Lee <bohyun(dot)lee(at)databricks(dot)com>
To: shihao zhong <zhong950419(at)gmail(dot)com>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, harrisontbooth(at)gmail(dot)com, Greg Sabino Mullane <htamfids(at)gmail(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] pg_upgrade: add --initdb option to create the new cluster automatically
Date: 2026-10-27 14:49:14
Message-ID: CAMPh8MrYxbKqaZzFHE9U7oVa6qrDwjm8XAG08S2=KACj_OBUQQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Shihao,

Thanks for the review. Both points are addressed in v10.

> 1. ICU rules are not copied.

Thanks for catching that. The patch is updated so the upgrade now copies
template0.daticurules.
I used a parameterized update so that multiline and long ICU rules are
preserved as well.

> 2. If a real run fails in the checks, the new cluster stays,

A real --initdb run now uses the existing cleanup when compatibility
checks fail, just as in --check mode. The same command can then be retried.
Failures after the upgrade begins still retain the cluster.

Best regards,
Bohyun

On Thu, Oct 22, 2026 at 5:46 AM shihao zhong <zhong950419(at)gmail(dot)com> wrote:

>
> Hi Bohyun,
>
> Thanks for v9. My points on v6 are all handled. Two new ones.
>
> 1. ICU rules are not copied. If the old template0 has daticurules,
> the new one has none and the upgrade still succeeds. A small fix is
> attached.
>
> 2. If a real run fails in the checks, the new cluster stays, and the
> same command then fails with "new cluster data directory is not
> empty". Nothing has been copied yet at that point, so could it be
> removed like in --check mode?
>
> Thanks,
> Shihao
>

Attachment Content-Type Size
v10-pg_upgrade-initdb.patch application/octet-stream 73.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rahila Syed 2026-10-27 14:59:37 Re: Fix concurrent-abort detection for subtransactions of prepared transactions
Previous Message Peter Eisentraut 2026-10-27 14:33:35 Clean up code comments for pg_wchar_tbl