FYI, you might wonder why so many bugs reported on pg_upgrade eventually
are bugs in pg_dump. Well, of course, partly is it because pg_upgrade
relies on pg_dump, but a bigger issue is that pg_upgrade will fail if
pg_dump or its restoration generate _any_ errors. My guess is that many
people are using pg_dump and restore and just ignoring errors or fixing
them later, while this is not possible when using pg_upgrade.
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Embrace your flaws. They make you human, rather than perfect,
which you will never be.