Feedback-ID: i76984098:Fastmail
Message-ID: <7766d4cc-e0b8-448e-9d79-1e0cc3e3098d@aklaver.com>
Date: Tue, 25 Nov 2025 14:13:46 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Restore Windows dump to Linux (locale issue)
To: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvZ2x1?= <ertan.kucukoglu@gmail.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>
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>
 <CAH2i4yeJmOHEW-rCZfTD8+94HNvXjPx2x6WoK4Xqnz-7k0ynTQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAH2i4yeJmOHEW-rCZfTD8+94HNvXjPx2x6WoK4Xqnz-7k0ynTQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/7766d4cc-e0b8-448e-9d79-1e0cc3e3098d%40aklaver.com>
Precedence: bulk

On 11/25/25 14:03, Ertan Küçükoglu wrote:
> Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>>, 26 Kas 2025 Çar, 00:20 tarihinde 
> şunu yazdı:
> 
>     On 11/25/25 13:06, Ertan Küçükoglu 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.

Alright I understand now.

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

It is a dump of the all the databases in the cluster as well as the 
cluster global objects, so the naming is correct. I just did not make 
the connection.


-- 
Adrian Klaver
adrian.klaver@aklaver.com