Request a Demo
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Date
Msg-id CANzqJaCq5_5ywjcfhH9CPdqwDq0Bid+5ajz6bzyL9GX2Upykpw@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
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!
Attachment

pgsql-admin by date:

Previous
From: Muhammet Kurtoğlu
Date:
Subject: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Next
From: Ron Watkins
Date:
Subject: pgping?