On 2024-08-06 16:06:51 +0530, Sandeep Thakkar wrote: > On Tue, Aug 6, 2024 at 10:57 AM Thomas Munro <thomas.munro@xxxxxxxxx> wrote: > > On Mon, Aug 5, 2024 at 8:50 PM Sandeep Thakkar > <sandeep.thakkar@xxxxxxxxxxxxxxxx> wrote: > > This issue is seen only on v16 and not the back branches (tested on 15 > and 14) and also confirmed by @Ertan Küçükoglu at https://github.com/ > EnterpriseDB/edb-installers/issues/127#issuecomment-2268371442 > > Does that mean you can reproduce the problem with initdb.exe directly > in a shell? That is, remove the EDB installer from the picture and > compare v15 and v16 with the exact command line options that > initcluster.vbs is using, or perhaps just: > > initdb.exe --locale="Turkish,Türkiye" --encoding=UTF-8 -D pgdata > > > yes, here is the output: > > c:\Program Files\PostgreSQL\16\bin>initdb.exe --encoding=UTF-8 -A > scram-sha-256 -U postgres -D "c:\Program Files\PostgreSQL\16\data" --locale > "Turkish,Türkiye" -W > The files belonging to this database system will be owned by user > "sandeep". > This user must also own the server process. > > The database cluster will be initialized with locale > "Turkish_Türkiye.1254". I assume that "1254" here is the code page. But you specified --encoding=UTF-8 above, so your default locale uses a different encoding than the template databases. I would expect that to cause problems if the template databases contain any charecters where the encodings differ (such as "ü" in the locale name). > c:\Program Files\PostgreSQL\15\bin>initdb.exe --encoding=UTF-8 -A > scram-sha-256 -U postgres -D "c:\Program Files\PostgreSQL\15\data" --locale > "Turkish,Türkiye" -W > XXX debug raw: getopt optarg = "Turkish,Türkiye" > XXX debug hex: getopt optarg = { 54 75 72 6b 69 73 68 2c 54 fc 72 6b 69 79 > 65 } > XXX debug txt: getopt optarg = { T u r k i s h , T ? r k i y > e } This also looks like window-1254 (or at least some ISO-8859 variant) to me. hp -- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@xxxxxx | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"
Attachment:
signature.asc
Description: PGP signature
