MIME-Version: 1.0
References: <CAH2i4yc95fmcbGJ1aOLfmOcjka1crOTCiuuoA30UEFVmj=iqsw@mail.gmail.com>
 <811312.1763935324@sss.pgh.pa.us> <SY7P300MB0761D22A982CFDA9052493CCA1D3A@SY7P300MB0761.AUSP300.PROD.OUTLOOK.COM>
 <CAH2i4yeY=BYwNaKDJpZKo+eDgwrt2PF3aOkLAGVSJeCW76JOLg@mail.gmail.com> <3e45822e-03f7-4d0a-a4b6-d0d3547903fb@aklaver.com>
In-Reply-To: <3e45822e-03f7-4d0a-a4b6-d0d3547903fb@aklaver.com>
From: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvZ2x1?= <ertan.kucukoglu@gmail.com>
Date: Wed, 26 Nov 2025 01:03:15 +0300
Message-ID: <CAH2i4yeJmOHEW-rCZfTD8+94HNvXjPx2x6WoK4Xqnz-7k0ynTQ@mail.gmail.com>
Subject: Re: Restore Windows dump to Linux (locale issue)
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Brent Wood <Brent.Wood@niwa.co.nz>, Tom Lane <tgl@sss.pgh.pa.us>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000005f4dc064472737b"
Archived-At: <https://www.postgresql.org/message-id/CAH2i4yeJmOHEW-rCZfTD8%2B94HNvXjPx2x6WoK4Xqnz-7k0ynTQ%40mail.gmail.com>
Precedence: bulk

--00000000000005f4dc064472737b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Adrian Klaver <adrian.klaver@aklaver.com>, 26 Kas 2025 =C3=87ar, 00:20 tari=
hinde
=C5=9Funu yazd=C4=B1:

> On 11/25/25 13:06, Ertan K=C3=BC=C3=A7=C3=BCkoglu wrote:
>
> >
> > Hello,
> >
>
> I am not understanding the below.
>
> > I manually created a database on the Linux system.
> > Took a database backup and restored it on the Linux system.
>
> That is what started this thread, an issue with a backup from a Windows
> machine.
>
> So where did you get a backup that you could restore?
>
>
Initially it was a pgdump_all backup. Which includes database creation
scripts.
I used only pg_dump backup. Where I restore in an already created database.

I called pg_dumpall backup as "cluster backup" . It may be my wrong choice
of naming.

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

<div dir=3D"ltr"><div dir=3D"ltr">Adrian Klaver &lt;<a href=3D"mailto:adria=
n.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt;, 26 Kas 2025 =C3=87=
ar, 00:20 tarihinde =C5=9Funu yazd=C4=B1:</div><div class=3D"gmail_quote gm=
ail_quote_container"><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 1=
1/25/25 13:06, Ertan K=C3=BC=C3=A7=C3=BCkoglu wrote:<br>
<br>
&gt; <br>
&gt; Hello,<br>
&gt; <br>
<br>
I am not understanding the below.<br>
<br>
&gt; I manually created a database on the=C2=A0Linux system.<br>
&gt; Took a database backup and restored it on the Linux system.<br>
<br>
That is what started this thread, an issue with a backup from a Windows <br=
>
machine.<br>
<br>
So where did you get a backup that you could restore?<br>
<br></blockquote><div><br></div><div>Initially it was a pgdump_all backup. =
Which includes database creation scripts.</div><div>I used only pg_dump bac=
kup. Where I restore in an already created database.</div><div><br></div><d=
iv>I called pg_dumpall backup as &quot;cluster backup&quot; . It may be my =
wrong choice of=C2=A0naming.=C2=A0</div></div></div>

--00000000000005f4dc064472737b--