public inbox for [email protected]
help / color / mirror / Atom feedFrom: Holger Jakobs <[email protected]>
To: [email protected]
Subject: Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Date: Fri, 19 Sep 2025 06:50:30 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANM7_8XvjXKZgQMYycoNoifvk25kGUpvoF6-dE6oxXkwzp9mOA@mail.gmail.com>
References: <CANM7_8XvjXKZgQMYycoNoifvk25kGUpvoF6-dE6oxXkwzp9mOA@mail.gmail.com>
Am 18.09.25 um 14:11 schrieb Muhammet Kurtoğlu:
> 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
>
>
>
>
> --
>
> *Muhammet KURTOĞLU*
>
> T: +90(312) 220 12 20 <tel:%2B90%28374%29%20262%2098%2000>
>
> F: +90(312) 286 00 10 <tel:%2B90%28374%29%20262%2090%2091>
>
> [email protected] <mailto:[email protected]>
>
>
>
>
>
Hi Muhammet,
You aren't using pg_upgrade as you are saying in the subject line, but
pg_restore for restoring, which means you did a pg_dump -Fc before.
In order to avoid the errors you have encountered, the safest bet ist
ALWAYS to use UTF8. Use UTF8 as encoding for ALL databases, and Collate
and CType language_country.UTF-8, in your case tr_TR.UTF-8. Don't bother
with the outdated iso8859x character sets.
UTF8 can handle all characters from all languages, special characters,
emojis and so on.
Make sure that the database cluster also has been initialised with the
correct encoding. Check whether the encoding of template1 database is
the same. Otherwise, run the initdb command again with correct settings,
see manpage of initdb.
This command works nonetheless
create database kurt with encoding = utf8 locale = tr_TR lc_collate =
'tr_TR.UTF-8' lc_ctype = 'tr_TR.UTF-8' locale_provider = libc template =
template0;
Selamlar
Holger
--
Holger Jakobs, Bergisch Gladbach, Germany
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: <[email protected]>
* 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