Re: pg_upgrade + Extensions - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: pg_upgrade + Extensions
Date
Msg-id BD9D093A-7386-4ACB-B13D-301661BDBE69@justatheory.com
Whole thread Raw
In response to Re: pg_upgrade + Extensions  (Smitha Pamujula <smitha.pamujula@iovation.com>)
Responses Re: pg_upgrade + Extensions  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On Jul 10, 2015, at 11:32 AM, Smitha Pamujula <smitha.pamujula@iovation.com> wrote:

> I just tested and yes that worked. Once we have the new library for the hostname, pg_upgrade is not complaining about
thehostname extension.  

Great, thank you Smitha -- and Tom for the pointer.

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

Best,

David


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PATCH: index-only scans with partial indexes
Next
From: Heikki Linnakangas
Date:
Subject: Re: Additional role attributes && superuser review