Date: Tue, 6 Aug 2024 13:44:05 +0200
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: Windows installation problem at post-install step
Message-ID: <20240806114405.qdwrok7ppfangowo@hjp.at>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <CAH2i4yfBEYmOzsvsT=D+ySpLpsEW2O1VfUwx9Ckd69du67YY_w@mail.gmail.com>
 <44b44ece-dce6-4b4f-b751-8787a5a071e0@aklaver.com>
 <CA+hUKGJA4pGEeZtfUUEuQmNNO7x16wZ+RWOeXP+tq3Hf4iu8oQ@mail.gmail.com>
 <CANFyU95Le+trZbtB1D4Y1FdUu4y_OJLxvJMi1Zb9WOWuf8KpqA@mail.gmail.com>
 <CAH2i4ycX3Q79uv431CxZ9dcyM5jkL=sJ8Z8rbNaNuKSK=Bprfg@mail.gmail.com>
 <CANFyU95q_WDM+utY3Mnrf1pwgASN3ZR1r6Fb+Zs7kXsPEDQQ2A@mail.gmail.com>
 <CANFyU94yoUCYovEZ9By2cpRbHsziRqndfPZ5qiTRD24CM57cEg@mail.gmail.com>
 <CANFyU959RhJvRAY7=8vgN-1f+qKFuK80uFvrR1kMoQMQqzKPQg@mail.gmail.com>
 <CA+hUKGK_LqmzEbR6YjyuQ9eAaecMfogv1e+E-dZVw=qULXtyGQ@mail.gmail.com>
 <CANFyU95vLi3K1FTZO82kYTAGX3B7TPkbWe8LAecaQtndH+EC9Q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="poslpaixllojv3o2"
Content-Disposition: inline
In-Reply-To: <CANFyU95vLi3K1FTZO82kYTAGX3B7TPkbWe8LAecaQtndH+EC9Q@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/20240806114405.qdwrok7ppfangowo%40hjp.at>
Precedence: bulk


--poslpaixllojv3o2
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2024-08-06 16:06:51 +0530, Sandeep Thakkar wrote:
> On Tue, Aug 6, 2024 at 10:57=E2=80=AFAM Thomas Munro <thomas.munro@gmail.=
com> wrote:
>=20
>     On Mon, Aug 5, 2024 at 8:50=E2=80=AFPM Sandeep Thakkar
>     <sandeep.thakkar@enterprisedb.com> wrote:
>     > This issue is seen only on v16 and not the back branches (tested on=
 15
>     and 14) and also confirmed by @Ertan K=C3=BC=C3=A7=C3=BCkoglu at http=
s://github.com/
>     EnterpriseDB/edb-installers/issues/127#issuecomment-2268371442
>=20
>     Does that mean you can reproduce the problem with initdb.exe directly
>     in a shell?=C2=A0 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:
>=20
>     initdb.exe --locale=3D"Turkish,T=C3=BCrkiye" --encoding=3DUTF-8 -D pg=
data
>=20
>=20
> yes, here is the output:
>=20
>     c:\Program Files\PostgreSQL\16\bin>initdb.exe --encoding=3DUTF-8 -A
>     scram-sha-256 -U postgres -D "c:\Program Files\PostgreSQL\16\data" --=
locale
>     "Turkish,T=C3=BCrkiye" -W
>     The files belonging to this database system will be owned by user
>     "sandeep".
>     This user must also own the server process.
>=20
>     The database cluster will be initialized with locale
>     "Turkish_T=C3=BCrkiye.1254".

I assume that "1254" here is the code page.
But you specified --encoding=3DUTF-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 "=C3=BC" in the locale name).


>     c:\Program Files\PostgreSQL\15\bin>initdb.exe --encoding=3DUTF-8 -A
>     scram-sha-256 -U postgres -D "c:\Program Files\PostgreSQL\15\data" --=
locale
>     "Turkish,T=C3=BCrkiye" -W
>     XXX debug raw: getopt optarg =C2=A0=3D "Turkish,T=C3=BCrkiye"
>     XXX debug hex: getopt optarg =C2=A0=3D { 54 75 72 6b 69 73 68 2c 54 f=
c 72 6b 69 79
>     65 }
>     XXX debug txt: getopt optarg =C2=A0=3D { T =C2=A0u =C2=A0r =C2=A0k =
=C2=A0i =C2=A0s =C2=A0h =C2=A0, =C2=A0T =C2=A0? =C2=A0r =C2=A0k =C2=A0i =C2=
=A0y
>     =C2=A0e =C2=A0}

This also looks like window-1254 (or at least some ISO-8859 variant) to
me.

        hp

--=20
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

--poslpaixllojv3o2
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmayDH0ACgkQ8g5IURL+
KF3+VA//X0zOMts0JMj168Hc7fQLq5dhyx1WsmsGkfDkCfb9cQJUoJ4QrWbqaD3J
W8HMzI/552I359c/6nTqFwRhckZObcnGYTdEIr3lFDshpZjSir4jAHCsC5W1j1vI
gx85EGRMQCgvclBJ6ChdCv8OqNPyepOrvYPCj1daUQDIpA++i3b58i899x/4rdzT
HKoy1H89lcFMgOxMH2OhtisEY6GWH5F9JKcjpYoXyL+HcnDsG+kJ3LhFCfLEcLyx
VEvf8f/rJa2JY+hmhznQb9LCMHtw0ZeFyKgosgmdN7L/+9510BkYGq3cHIDHiOX9
zkwTaQNaGoIEYbJmlvCaD855fXbeuItcCvXJFmSvk+H1R9gMDvufe0LxZArbSPM3
Ce+Gs8KD3bgoJcXj/QRtIl9QT+1raee+/Evwcpp9OByxrLRk6DKE540qFNA2LEJU
79xA31XXdLlkbYkgDU/+4cQOpVfOMecaVsd4VxZ2zadfT2uhSfCULywFnOuySYig
4TPno5wNjN0EZAAqdivku02OsWDNqbWBNT4O/fPA3L+/zjZS0Ir+Ps/KlcX7EIb7
sG2tZyLOnb4tB8VYomsg7OvvvoSi2VNIRM2YMTTgRUQl4XXtwVo1QQTu/4I2Gd2O
p9Z6IydpIkMsU1bngCiTIa5h2nvN86pOvyJj0zThSoipxCBa3f0=
=iW7U
-----END PGP SIGNATURE-----

--poslpaixllojv3o2--