Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Thu, Sep 18, 2025 at 8:12 AM Muhammet Kurtoğlu <muhammet.kurtoglu@xxxxxxxxxxxxx> 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

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!