Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 13.0 \(3608.40.2.2.4\))
Subject: Re: pg_upgrade from 9.5.10 to 12 fails with encoding issue
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CAMTQpJAxPKOFNmNjPCxfQzjb_mqH3sMuZ0hK138wZ4L5VAPTMQ@mail.gmail.com>
Date: Sun, 19 Jan 2020 22:37:04 -0700
Cc: pgsql-admin@lists.postgresql.org,
 pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <3BA55A27-5797-4CF8-BF74-DD8B9B1EE8B0@elevated-dev.com>
References: 
 <CAMTQpJAxPKOFNmNjPCxfQzjb_mqH3sMuZ0hK138wZ4L5VAPTMQ@mail.gmail.com>
To: Shrikant Bhende <shrikantpostgresql@gmail.com>
Precedence: bulk

> On Jan 19, 2020, at 10:00 PM, Shrikant Bhende =
<shrikantpostgresql@gmail.com> wrote:
>=20
> Hello community,=20
>=20
> I am trying to upgrade a cluster of version 9.5.19 to version 12.1 but =
seems like upgrade is getting failed because of database encoding issue, =
I am getting below error while running pg_upgrade command with -c=20
>=20
> "lc_collate values for database "postgres" do not match:  old =
"en_US.UTF-8", new "C.UTF-8" Failure, exiting",=20
>=20
> I have tried to create new cluster f version 12 using initdb =
--encoding parameter but it create encoding as C.UTF-8 only and old =
cluster is with encoding en_us_UTF-8.
> Kindly assist to resolve this issue.
>=20
> Thanks and regards

I'm going to guess that you need --locale as well.