Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters - Mailing list pgsql-general

From Ken Yeung
Subject Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters
Date
Msg-id VI1PR01MB4926A72FAD40EE99A353E7B7C0879@VI1PR01MB4926.eurprd01.prod.exchangelabs.com
Whole thread Raw
Responses Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters  (Thomas Boussekey <thomas.boussekey@gmail.com>)
Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
In the course of upgrading a bunch of database clusters from 10 to 14 using pg_upgrade tool, some databases result in
thefollowing error recorded in pg_upgrade_dump_1.log, such that cluster upgrade fails. 
FATAL:  password authentication failed for user "postgres"

This was done on Microsoft Windows 11.
PostgreSQL 10 and 14 used are built using Visual Studio 2015.
Only a small number of database clusters has this problem, around 2 of 200.
It appears these database are used from earlier cluster upgrade from 9.4 to 10 as well.

It would be very helpful if there is any possible workaround to overcome this problem.

I attached a sample pg_upgrade_dump_1.log reported this error.
Attachment

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Get the table creation DDL
Next
From: "Walter Dörwald"
Date:
Subject: Re: Get the table creation DDL