Re: [GENERAL] could not load library "$libdir/sslutils": inpg_upgrade process

On 01/03/2017 04:39 PM, DrakoRod wrote:
> 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:

 From what I gather sslutils is a EDB extension for their Advanced
Server, is that correct?

Are you doing this with an EDB install?

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


--
Adrian Klaver
adrian.klaver@aklaver.com