Message-ID: <54BE9AA9.8040608@gmail.com>
Date: Tue, 20 Jan 2015 13:12:57 -0500
From: John Scalia <jayknowsunix@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:31.0) Gecko/20100101 Thunderbird/31.4.0
MIME-Version: 1.0
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: cannot drop an extension
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi all,

My pg_upgrade woes continue... The primary server, V9.3.3, was originally used as a testbed for pgpool-II, although we ended up chosing pacemaker and corosync instead. When pgpool 
was installed, the instructions have you add a pgpool-regclass extension. Naturally, trying to upgrade to V9.4.0 fails and pg_upgrade writes a loadable_libraries.txt saying that 
$libdir/pgpool-regclass cannot be found. So, I restarted the original database, and connected to both my csg_db instance and to the template1 instance, then tried issuing a "drop 
extension pgpool-reglass", but the both the db's say it does not exist. I also tried dropping it by enclosing the extension name in quotes, both single and double with no joy. 
Then, I tried looking in pg_extensions, but I didn't see any similar entry there either. How can I get rid of this extension so that pg_upgrade will complete successfully? I've 
asked on the pgpool admin list, but as it's the middle of the night in Japan, I'm not expecting an immediate answer, if any.
--
Jay


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin