MIME-Version: 1.0
From: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvZ2x1?= <ertan.kucukoglu@gmail.com>
Date: Mon, 24 Nov 2025 00:41:35 +0300
Message-ID: <CAH2i4yc95fmcbGJ1aOLfmOcjka1crOTCiuuoA30UEFVmj=iqsw@mail.gmail.com>
Subject: Restore Windows dump to Linux (locale issue)
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ca2528064449e973"
Archived-At: <https://www.postgresql.org/message-id/CAH2i4yc95fmcbGJ1aOLfmOcjka1crOTCiuuoA30UEFVmj%3Diqsw%40mail.gmail.com>
Precedence: bulk

--000000000000ca2528064449e973
Content-Type: text/plain; charset="UTF-8"

Hello,

I am using PostgreSQL 18.1 on a Windows system.
I need to move that database to a Linux system of the same version number.

Windows system use locales name as tr-TR (this is UTF-8 locale)
Linux system use locale name as tr_TR.UTF-8

My cluster backup gives error at restore (I think because of that locale
naming difference) as below

psql:/db.dump:133: ERROR:  invalid LC_COLLATE locale name: "tr-TR"

And a bunch of other errors below.

What can I do to complete this migration?

Thanks & Regards,
Ertan

--000000000000ca2528064449e973
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<div><br></div><div>I am using PostgreSQL 18.1 on a =
Windows system.</div><div>I need to move that database to a Linux system of=
 the same=C2=A0version number.</div><div><br></div><div>Windows system use =
locales name as tr-TR (this is UTF-8 locale)</div><div>Linux system use loc=
ale name as tr_TR.UTF-8</div><div><br></div><div>My cluster backup gives er=
ror at restore (I think because of that locale naming difference) as below<=
/div><div><br></div><div>psql:/db.dump:133: ERROR: =C2=A0invalid LC_COLLATE=
 locale name: &quot;tr-TR&quot;</div><div><br></div><div>And a bunch of oth=
er errors below.</div><div><br></div><div>What can I do to complete=C2=A0th=
is migration?</div><div><br></div><div>Thanks &amp;=C2=A0Regards,</div><div=
>Ertan</div></div>

--000000000000ca2528064449e973--