pg_upgrade with an extension name change

Started by Christophe Pettusabout 10 years ago2 messagesgeneral
Jump to latest
#1Christophe Pettus
xof@thebuild.com

I'm attempting to upgrade a database from 9.2 to 9.5 using pg_upgrade. The 9.2 database has the "orafunc" extension installed, which appears to have changed names to "orafce". pg_upgrade complains that it can't find "orafunc" on 9.5, which is true. Is there a standard way of handling this situation?

--
-- Christophe Pettus
xof@thebuild.com

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Christophe Pettus (#1)
Re: pg_upgrade with an extension name change

On Fri, Apr 8, 2016 at 12:15:27PM -0700, Christophe Pettus wrote:

I'm attempting to upgrade a database from 9.2 to 9.5 using pg_upgrade.
The 9.2 database has the "orafunc" extension installed, which appears
to have changed names to "orafce". pg_upgrade complains that it can't
find "orafunc" on 9.5, which is true. Is there a standard way of
handling this situation?

Uh, I would uninstall the extension on the old cluster and reinstall it
on the new one.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +

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