Restore Windows dump to Linux (locale issue)

Поиск
Список
Период
Сортировка
От Ertan Küçükoglu
Тема Restore Windows dump to Linux (locale issue)
Дата
Msg-id CAH2i4yc95fmcbGJ1aOLfmOcjka1crOTCiuuoA30UEFVmj=iqsw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Restore Windows dump to Linux (locale issue)
Re: Restore Windows dump to Linux (locale issue)
Re: Restore Windows dump to Linux (locale issue)
Список 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 по дате отправления: