Upgrading from postgresql 11 to postgresql 17 using pg_upgrade

From: Muhammet Kurtoğlu <muhammet(dot)kurtoglu(at)bisoft(dot)com(dot)tr>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Date: 2025-09-18 12:11:37
Message-ID: CANM7_8XvjXKZgQMYycoNoifvk25kGUpvoF6-dE6oxXkwzp9mOA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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: image.png]

please help

--

*Muhammet KURTOĞLU*

T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>

F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>

muhammet(dot)kurtoglu(at)bisoft(dot)com(dot)tr <caner(dot)olkan(at)bisoft(dot)com(dot)tr>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-09-18 14:15:24 Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Previous Message Jishnu Sygal 2025-09-17 19:23:14 Re: [Architecture] Multi-Environment pg_cron for Automated Partition Management