Re: Move defaults toward ICU in 16?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>, Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Move defaults toward ICU in 16?
Date: 2023-02-24 23:54:15
Message-ID: f2b896d1476915862b99c2514c298c052e048c57.camel@j-davis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 2023-02-17 at 15:07 -0800, Jeff Davis wrote:
> 2. Update the pg_database entry for template0. This has less
> potential
> for surprise in case people are actually using template0 for a
> template.

New patches attached.

0001: default autoconf to build with ICU (meson already uses 'auto')
0002: update template0 in new cluster (as described above)
0003: default initdb to use ICU

Updating template0, as in 0002, seems straightforward and unsurprising,
since only template0 is preserved and it was only initialized for the
purposes of upgrading. Also, template0 is not sensitive to locale
settings, and doesn't even have the datcollversion set. The patch
updates encoding, datlocprovider, datcollate, datctype, and
daticulocale on the new cluster. No doc update, because there are some
initdb settings (like checksums) which still need to be compatible
between the old and the new cluster.

--
Jeff Davis
PostgreSQL Contributor Team - AWS

Attachment Content-Type Size
v4-0001-Build-ICU-support-by-default.patch text/x-patch 8.6 KB
v4-0002-pg_upgrade-copy-locale-and-encoding-information-t.patch text/x-patch 12.8 KB
v4-0003-Use-ICU-by-default-at-initdb-time.patch text/x-patch 17.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vik Fearing 2023-02-25 02:11:03 Re: Disable vacuuming to provide data history
Previous Message Stephen Frost 2023-02-24 22:50:30 Re: Disable rdns for Kerberos tests