Currently checking the procedure for upgrading Postgres from 10.4 to 11.5.
When I run pg_upgrade
with the "check" option, I have the following messages. If you have any comments about this, about how you have fixed the issue, I would be grateful.
bash-4.2$ /usr/pgsql-11/bin/pg_upgrade \
> -b /usr/pgsql-10/bin \
> -B /usr/pgsql-11/bin \
> -d /var/lib/pgsql/10/data \
> -D /var/lib/pgsql/11/data \
> -c pgsql-10/ pgsql-11/
Performing Consistency Checks on Old Live Server
------------------------------------------------
Checking cluster versions
ok
Checking database user is the install user
ok
Checking database connection settings
ok
Checking for prepared transactions
ok
Checking for reg* data types in user tables
ok
Checking for contrib/isn with bigint-passing mismatch
ok
encodings for database "postgres" do not match: old "SQL_ASCII", new "UTF8"
Failure, exiting