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 <and...@dunslane.net> wrote: > > > On Fri, Jul 10, 2015 at 5:05 PM, David E. Wheeler <da...@justatheory.com> > wrote: > >> On Jul 10, 2015, at 11:32 AM, Smitha Pamujula < >> smitha.pamuj...@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) > > cheers > > andrew > > -- Smitha Pamujula Database Administrator // The Watch Woman Direct: 503.943.6764 Mobile: 503.290.6214 // Twitter: iovation www.iovation.com
