Thread: Dropping a loadable library

Hi all,

My efforts with pg_upgrade have hit a new, what should be easy solve, problem. It failed due to a loadable library
beingpresent in 9.3.3 that I really don't need any longer. My  
problem is, how do I drop a library from the 9.3.3 instance? I've done some internet searching, but haven't found
anythinguseful. 

Anyone?
--
Jay

Hi,

On Mon, 2015-01-19 at 13:49 -0500, John Scalia wrote:

> My efforts with pg_upgrade have hit a new, what should be easy solve,
> problem. It failed due to a loadable library being present in 9.3.3
> that I really don't need any longer. My
> problem is, how do I drop a library from the 9.3.3 instance? I've done
> some internet searching, but haven't found anything useful.

If that is an extension, you can drop it with DROP EXTENSION command --
otherwise, run uninstall script and then remove shared library.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR