Hi Heikki, > Stepping back a bit though, what is the point of having any of these > -- encoding, datcollate, datctype, daticurules -- set on template0?
They are the defaults initdb picked, and createdb -T template0 uses them. So I think pg_upgrade should carry them over as they are. I'll leave it to you whether that design should change. > So if you specify "initdb --icu-rules", you cannot create databases with > any other locale provider. This is because createdb() copies the template's ICU rules even for a non-ICU database. The attached patch fixed it and it need to back to 17. Thanks, Shihao
0001-Don-t-inherit-ICU-rules-from-template-for-non-ICU-da.patch
Description: Binary data
