Re: pg_upgrade doesn't copy ICU rules on template0

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Jeff Davis <pgsql(at)j-davis(dot)com>, shihao zhong <zhong950419(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bohyun Lee <bohyun(dot)lee(at)databricks(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_upgrade doesn't copy ICU rules on template0
Date: 2026-11-20 10:24:59
Message-ID: 1a71efa7-299d-4300-afd2-cf242b1f5df4@iki.fi
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 19/11/2026 06:07, Jeff Davis wrote:
> On Sat, 2026-10-31 at 20:47 -0400, shihao zhong wrote:
>> The attached patch fixed it and it need to back to 17.
>
> Committed. Thank you!

Thanks for that!

The original issue that daticurules was not copied by pg_upgrade
remained. I committed the fix for that from this thread now too. (
v1-pg_upgrade-template0-icu-rules.patch with just minor changes)

I still question whether it's sensible for template0 to have any of
these locale settings in the first place. But at least daticurules is
now handled consistently with the other ones.

- Heikki

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2026-11-20 10:37:24 Re: Report buffer access strategies in EXPLAIN
Previous Message Tomas Vondra 2026-11-20 10:04:52 Re: Parallel GIN, BRIN builds fail to maintain ii_BrokenHotChain