Re: pg_upgrade + Extensions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_upgrade + Extensions
Date
Msg-id 20150831221825.GE17858@momjian.us
Whole thread Raw
In response to Re: pg_upgrade + Extensions  (Smitha Pamujula <smitha.pamujula@iovation.com>)
Responses Re: pg_upgrade + Extensions  (Smitha Pamujula <smitha.pamujula@iovation.com>)
List pgsql-hackers
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. +



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Horizontal scalability/sharding
Next
From: Alexander Korotkov
Date:
Subject: Re: WIP: Access method extendability