On Mon, 2020-09-28 at 10:02 +0200, Paul Förster wrote:
> I have a general question about the use of ICU. Currently, we have PostgreSQL compiled
> from source (Linux) without ICU support. All database clusters and databases are UTF8
> and of course relying on glibc.
>
> With the sooner or later upcoming glibc release 2.28, there will probably a big reindex
> operation be necessary. To avoid that, I'd like to use ICU.
>
> Compiling --with-icu into the new software, is there a way to make a whole database cluster
> and all its databases use an ICU without having to manually change all tables or indexes?
There have been efforts to add this functionality:
https://www.postgresql.org/message-id/flat/5e756dd6-0e91-d778-96fd-b1bcb06c161a%402ndquadrant.com
but it didn't get done.
Your best bet is to manually change the definition of all columns to use the new collation.
psql's \gexec may help.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com