could not load library "$libdir/sslutils": in pg_upgrade process

From: DrakoRod <drakoflames(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: could not load library "$libdir/sslutils": in pg_upgrade process
Date: 2017-01-04 00:39:03
Message-ID: 1483490343562-5937304.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi folks!

I'm try to upgrade version from 9.3.5 to 9.6.1, but in the 9.3.5 I installed
the sslutils to monitoring server with a agent, but now when I want upgrade
show this error pg_upgrade:

/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/

with a cat in loadable_libraries.txt show this:

/could not load library "$libdir/sslutils":
ERROR: could not access file "$libdir/sslutils": No such file or directory
/

I installed in the new version 9.6.1 the same sslutil's version and process
that 9.3.5 and show this error:

/Consult the last few lines of "pg_upgrade_dump_68706.log" for
the probable cause of the failure.
Failure, exiting
"/opt/PostgreSQL/9.6/bin/pg_ctl" -w -D "/opt/PostgreSQL/9.6/data" -o "" -m
fast stop >> "pg_upgrade_server.log" 2>&1
[postgres(at)server ~]$ tailf pg_upgrade_dump_68706.log
pg_restore: creating COMMENT "public.FUNCTION
"openssl_rsa_generate_key"(integer)"
pg_restore: creating FUNCTION "public.openssl_rsa_key_to_csr("text", "text",
"text", "text", "text", "text", "text")"
pg_restore: creating COMMENT "public.FUNCTION
"openssl_rsa_key_to_csr"("text", "text", "text", "text", "text", "text",
"text")"
pg_restore: creating FUNCTION "public.sslutils_version()"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 608; 1255 71731 FUNCTION
sslutils_version() pem
pg_restore: [archiver (db)] could not execute query: ERROR: could not find
function "sslutils_version" in file
"/opt/PostgreSQL/9.6/lib/postgresql/sslutils.so"
Command was: CREATE FUNCTION "sslutils_version"() RETURNS "text"
LANGUAGE "c" IMMUTABLE
AS '$libdir/sslutils', 'sslutils_version'...
/

Then, I try uninstall the sslutils in the old cluster and recreate new
cluster clean of 9.6.1, but show the same error:

/could not load library "$libdir/sslutils":
ERROR: could not access file "$libdir/sslutils": No such file or directory
/

I restarted SO, unseted enviroment variables, but the same error.
Any Suggestions?

Best Regards.

DrakoRod

-----
Dame un poco de fe, eso me bastarĂ¡.
Rozvo Ware Solutions
--
View this message in context: http://postgresql.nabble.com/could-not-load-library-libdir-sslutils-in-pg-upgrade-process-tp5937304.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-01-04 00:53:10 Re: could not load library "$libdir/sslutils": in pg_upgrade process
Previous Message Ravi Kapoor 2017-01-03 21:00:56 Re: questions about 2nd index on one column