Re: pg_upgrade + Extensions

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(at)dunslane(dot)net> wrote:

>
>
> 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
>
>

--
Smitha Pamujula
Database Administrator // The Watch Woman

Direct: 503.943.6764
Mobile: 503.290.6214 // Twitter: iovation
www.iovation.com