Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Дата
Msg-id CANzqJaCq5_5ywjcfhH9CPdqwDq0Bid+5ajz6bzyL9GX2Upykpw@mail.gmail.com
обсуждение исходный текст
Ответ на Upgrading from postgresql 11 to postgresql 17 using pg_upgrade  (Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>)
Список pgsql-admin
Дерево обсуждения
On Thu, Sep 18, 2025 at 8:12 AM 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


What PG17 version?
What exact pg_upgrade command (with options, and all output) did you run?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
Вложения

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