Cybersecurity
DevOps Cloud
IT Operations Cloud
Environment
NA
Situation
When upgrading NA, with different Postgress instances in the OS level, and an error in the DB upgrade appears:
running pgUpgrade script which failed, loadable_libraries.txt file ..
Creating dump of database schemas
na
postgres
template1
ok
Checking for presence of required libraries fatal
Your installation references loadable libraries that are missing from the
new installation. You can add these libraries to the new installation,
Failure, exiting
Error occurred while migrating data:
pg_upgrade tool failed
Error occurred while migrating data: pg_upgrade tool failed
and in the loadable_libraries.txt shows:
$libdir/pgstattuple
For resolution, refer to the complete knowledge article