Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade

Поиск
Список
Период
Сортировка
От concur dev
Тема Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Дата
Msg-id CAN75wdCunODQEQYYmTNsV8YdXXxeEb7j9rmZLYVC5YwM8TSqdw@mail.gmail.com
обсуждение исходный текст
Ответ на Upgrading from postgresql 11 to postgresql 17 using pg_upgrade  (Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>)
Список pgsql-admin
Дерево обсуждения

hi Muhammet!
The locale tr_TR.iso88599 only works with LATIN5, not UTF-8. Either create the DB with tr_TR.UTF-8 and restore without --create, or switch to LATIN5. Locale and encoding must match.

Regards
Ashish

On Thu, Sep 18, 2025 at 2:12 PM Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr> wrote:
Hi
 during upgrade we encounter 

pg_restore: error: could not execute query: ERROR: encoding "UTF8" does not match locale "tr_TR.iso88599" DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN5". Command was: CREATE DATABASE "zzz" WITH TEMPLATE = template0 OID = 84322 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'tr_TR.iso88599' TABLESPACE = "zz";

postgresql 11 database list


image.png

please help


--
Вложения

В списке pgsql-admin по дате отправления: