Re: pg_upgrade + Extensions - Mailing list pgsql-hackers
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@momjian.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@momjian.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
www.iovation.com
pgsql-hackers by date: