Home > mailing lists

Upgrading from postgresql 11 to postgresql 17 using pg_upgrade - Mailing list pgsql-admin

From	Muhammet Kurtoğlu
Subject	Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
Date	September 18 15:11:37
Msg-id	CANM7_8XvjXKZgQMYycoNoifvk25kGUpvoF6-dE6oxXkwzp9mOA@mail.gmail.com Whole thread Raw
Responses	Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade Re: Upgrading from postgresql 11 to postgresql 17 using pg_upgrade
List	pgsql-admin

Tree view

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