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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
