On Wed, Sep 12, 2012 at 12:03:21PM +0200, Thomas Kellerer wrote: > Thomas Kellerer wrote on 12.09.2012 11:09: > >Is there a way to find out which function (or extension?) is using those libraries in order to remove that dependency? > > What I ended up doing is to search through my pg_dump backups and I found the "offending" database. > After removing the functions in question, everything went smoothly. > > Is there a better way to find those functions rather than doing a grep on the dump files? Well, pg_upgrade uses SQL queries to find those entries, so you could turn on logging and look at the SQL queries that look in the pg_proc table for such entries. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
