On 2024-08-06 16:06:51 +0530, Sandeep Thakkar wrote: > On Tue, Aug 6, 2024 at 10:57 AM Thomas Munro <[email protected]> wrote: > > On Mon, Aug 5, 2024 at 8:50 PM Sandeep Thakkar > <[email protected]> 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.
|_|_) | |
| | | [email protected] | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
