Request a Demo
Home   >   mailing lists

Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade - Mailing list pgsql-admin

From concur dev
Subject Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Date
Msg-id CAN75wdCunODQEQYYmTNsV8YdXXxeEb7j9rmZLYVC5YwM8TSqdw@mail.gmail.com
Whole thread Raw
In response to Upgrading from postgresql 11 to postgresql 17 using pg_upgrade  (Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>)
List pgsql-admin
Tree view

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


--
Attachment

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade