Re: pg_upgrade + Extensions

Thank you Bruce. So far installing it before have been working well so we
will continue with that plan.

I think it would help if its noted somewhere in the document as it would
have helped us save some time understanding why it was failing and why it
was looking for json_build.

On Mon, Aug 31, 2015 at 3:18 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> On Tue, Jul 14, 2015 at 09:48:59AM -0700, Smitha Pamujula wrote:
> > This error will go away only if I install the new json_build94.
> > ........................................................................
>
> > I was under the impression that we dont need to get the json_build
> > libraries for 94. But the upgrade wont go forward without that. Are we
> > missing doing something here or is it necessarty to get json_build94
> > before upgrade.
>
> I am coming very late to this discussion, but I do have some
> information. Basically, pg_upgrade is trying to predict if the
> dump/restore will fail by checking references to shared objects in the
> old cluster. It sees a reference to json_build in the old cluster and
> assumes this is needed in the new cluster, when in fact it isn't.
>
> We could have hard-coded this knowledge into 9.4 pg_upgrade if we had
> known it. The simple solution is to install json_build94 as you did,
> run pg_upgrade, then just uninstall json_build94 as nothing depends on
> it. Not sure if this should be in the pg_upgrade docs or not.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
>

--
Smitha Pamujula
Database Administrator // The Watch Woman

Direct: 503.943.6764
Mobile: 503.290.6214 // Twitter: iovation
www.iovation.com