Re: pg_upgrade + Extensions

On Fri, Jul 10, 2015 at 5:05 PM, David E. Wheeler <david(at)justatheory(dot)com>
wrote:

> On Jul 10, 2015, at 11:32 AM, Smitha Pamujula <
> smitha(dot)pamujula(at)iovation(dot)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(at)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