Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade

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(dot)kurtoglu(at)bisoft(dot)com(dot)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: 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>
>
>
>
>
>
>
>
>