Re: Restore Windows dump to Linux (locale issue)

On 11/25/25 14:03, Ertan Küçükoglu wrote:
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com