Re: pg_upgrade + Extensions - Mailing list pgsql-hackers
Yes. I have checked that the extension didn't exist in any of the databases. I used \dx to see if there was json_build was listed and i didnt see any. Is that sufficient to check its existence. I am about to do another testing in a few minutes on a different machine. I will capture before/after shots
Thanks
On Fri, Jul 10, 2015 at 4:26 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
On Fri, Jul 10, 2015 at 5:05 PM, David E. Wheeler <david@justatheory.com> wrote:On Jul 10, 2015, at 11:32 AM, Smitha Pamujula <smitha.pamujula@iovation.com> wrote:
> Your installation references loadable libraries that are missing from the
> new installation. You can add these libraries to the new installation,
> or remove the functions using them from the old installation. A list of
> problem libraries is in the file:
> loadable_libraries.txt
>
> Failure, exiting
> [postgres@pdxdvrptsrd04 ~]$ cat loadable_libraries.txt
> Could not load library "json_build"
> ERROR: could not access file "json_build": No such file or directory
So you drop the json_build extension before upgrading, but pg_upgrade still complains that it’s missing? That seems odd.Are you sure the extension was uninstalled from every database in the cluster? This seems likely to occur when you forgot to uninstall it from some database (e.g. template1)cheersandrew
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: