Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
FS#47656 - [postgresql] Missing pg_upgrade_support.so fails upgrading from version 9.4
Attached to Project:
Arch Linux
Opened by Ari Caldeira (aricaldeira) - Thursday, 07 January 2016, 12:24 GMT
Last edited by Dan McGee (toofishes) - Wednesday, 23 March 2016, 11:32 GMT
Opened by Ari Caldeira (aricaldeira) - Thursday, 07 January 2016, 12:24 GMT
Last edited by Dan McGee (toofishes) - Wednesday, 23 March 2016, 11:32 GMT
|
DetailsDescription:
Missing pg_upgrade_support.so fails upgrading from version 9.4 Additional info: From testing repo: postgrsql 9.5.0-1 postgresql-old-upgrade 9.4.5-1 postgres/data has been continually upgraded since version 9.2, to 9.3 and then again to 9.4 Steps to reproduce: Upgrade using testing repo Stop old postgresql if already running Follow steps to upgrade from Wiki: https://wiki.archlinux.org/index.php/PostgreSQL#Upgrading_PostgreSQL Result of pg_upgrade ends with the following text: ==================== 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, or remove the functions using them from the old installation. A list of problem libraries is in the file: loadable_libraries.txt Failure, exiting ==================== I don't know wether I can trust the upgrade went well, and the resulting data is reliable, or the missing library is really important to the process. |
This task depends upon
Closed by Dan McGee (toofishes)
Wednesday, 23 March 2016, 11:32 GMT
Reason for closing: Works for me
Wednesday, 23 March 2016, 11:32 GMT
Reason for closing: Works for me
I see this in the 9.5 release notes (http://www.postgresql.org/docs/current/static/release-9-5.html):
* In connection with this change, the functionality previously provided by the pg_upgrade_support module has been moved into the core server.
I wonder if the error is not quite correct? Might be wise to bring this up on the PG mailing list.
=====================================
Could not load library "$libdir/pg_upgrade_support"
ERROR: could not access file "$libdir/pg_upgrade_support": File or directory not found
=====================================
pg_upgrade -b /opt/pgsql-9.4/bin/ -B /usr/bin/ -d /var/lib/postgres/data-9.4/ -D ./data/
Performing Consistency Checks
-----------------------------
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* system OID user data types ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating dump of global objects ok
Creating dump of database schemas
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,
or remove the functions using them from the old installation. A list of
problem libraries is in the file:
loadable_libraries.txt
Could not load library "$libdir/pg_upgrade_support"
ERROR: could not access file "$libdir/pg_upgrade_support": No such file or directory
https://wiki.archlinux.org/index.php/PostgreSQL#Troubleshooting
"
It means you have leftovers from old failed pg_upgrade attempts that you never completed. So you'll need to start postgres with old data and
in each database execute DROP SCHEMA IF EXISTS binary_upgrade CASCADE;
"