public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muhammet Kurtoğlu <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Date: Thu, 18 Sep 2025 15:11:37 +0300
Message-ID: <CANM7_8XvjXKZgQMYycoNoifvk25kGUpvoF6-dE6oxXkwzp9mOA@mail.gmail.com> (raw)

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]
  Subject: Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
  In-Reply-To: <CANM7_8XvjXKZgQMYycoNoifvk25kGUpvoF6-dE6oxXkwzp9mOA@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