Restore Windows dump to Linux (locale issue) - Mailing list pgsql-general

From Ertan Küçükoglu
Subject Restore Windows dump to Linux (locale issue)
Date
Msg-id CAH2i4yc95fmcbGJ1aOLfmOcjka1crOTCiuuoA30UEFVmj=iqsw@mail.gmail.com
Whole thread Raw
Responses Re: Restore Windows dump to Linux (locale issue)
Re: Restore Windows dump to Linux (locale issue)
Re: Restore Windows dump to Linux (locale issue)
List pgsql-general
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ODBC fails to recognize event trigger removal
Next
From: Adrian Klaver
Date:
Subject: Re: Restore Windows dump to Linux (locale issue)