From: Bruce Momjian <bruce@momjian.us>
To: Thomas Kellerer <spam_eater@gmx.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Missing loadable libraries when running pg_upgrade 9.1 -> 9.2
Date: Wed, 12 Sep 2012 14:11:43 -0400
Message-ID: <20120912181143.GA1850@momjian.us> (raw)
In-Reply-To: <k2pmkk$5p6$1@ger.gmane.org>
References: <k2pjfn$a0u$1@ger.gmane.org>
<k2pmkk$5p6$1@ger.gmane.org>
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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, spam_eater@gmx.net
Subject: Re: Missing loadable libraries when running pg_upgrade 9.1 -> 9.2
In-Reply-To: <20120912181143.GA1850@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox