Re: pg_upgrade + Extensions - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_upgrade + Extensions
Date
Msg-id CAD5tBcLwmrSMt7nWOtuB_8TS+Z5uDRABik--X9fzbwJaH6rtSQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade + Extensions  ("David E. Wheeler" <david@justatheory.com>)
Responses Re: pg_upgrade + Extensions  (Smitha Pamujula <smitha.pamujula@iovation.com>)
List pgsql-hackers


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)

cheers

andrew

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Reusing abbreviated keys during second pass of ordered [set] aggregates
Next
From: Jim Nasby
Date:
Subject: Re: Freeze avoidance of very large table.