Restore Windows dump to Linux (locale issue)

From: Ertan Küçükoglu <ertan(dot)kucukoglu(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Restore Windows dump to Linux (locale issue)
Date: 2025-11-23 21:41:35
Message-ID: CAH2i4yc95fmcbGJ1aOLfmOcjka1crOTCiuuoA30UEFVmj=iqsw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-11-23 21:47:27 Re: Restore Windows dump to Linux (locale issue)
Previous Message Adrian Klaver 2025-11-23 21:36:24 Re: ODBC fails to recognize event trigger removal