public inbox for [email protected]
help / color / mirror / Atom feedFrom: concur dev <[email protected]>
To: Muhammet Kurtoğlu <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Date: Fri, 19 Sep 2025 07:01:27 +0200
Message-ID: <CAN75wdCunODQEQYYmTNsV8YdXXxeEb7j9rmZLYVC5YwM8TSqdw@mail.gmail.com> (raw)
In-Reply-To: <CANM7_8XvjXKZgQMYycoNoifvk25kGUpvoF6-dE6oxXkwzp9mOA@mail.gmail.com>
References: <CANM7_8XvjXKZgQMYycoNoifvk25kGUpvoF6-dE6oxXkwzp9mOA@mail.gmail.com>
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 <
[email protected]> 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>
>
> [email protected] <[email protected]>
>
>
>
>
>
>
>
>
Attachments:
[image/png] image.png (220.2K, 3-image.png)
download | view image
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
In-Reply-To: <CAN75wdCunODQEQYYmTNsV8YdXXxeEb7j9rmZLYVC5YwM8TSqdw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox