Re: Restore Windows dump to Linux (locale issue)

Adrian Klaver <adrian.klaver@aklaver.com>

From: Adrian Klaver <adrian.klaver@aklaver.com>

To: Ertan Küçükoglu <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>

Date: 2025-11-25T22:13:46Z

Lists: pgsql-general

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