Re: 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: Re: could not load library "$libdir/sslutils": in pg_upgrade process
Date: 2017-01-05 00:13:49
Message-ID: 1483575229213-5937545.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian, Tom

Finally I did upgrade version but I've removed database pem (Postgres
Enterprise Manager) I guess that this database has some link in some
function to sslutils, because pg_upgrade showed the above errors while
upgraded this database.

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

But when I removed pem database the process pg_upgrade finished correctly.

Thanks for your help!!

-----
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-tp5937304p5937545.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2017-01-05 00:18:57 Re: Index impact on update?
Previous Message Tomas Vondra 2017-01-05 00:08:25 Re: Performance degradation when using auto_explain