Re: pg_upgrade + Extensions

Tom,

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

Another thing we found is this. We needed to drop json_build extension
before the upgrade. However the upgrade fails with the following error and
the way to resolve it is to install json_build94 library. Any ideas why
this might be?

/usr/pgsql-9.4/bin/pg_upgrade --check --link
...
....
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

Thanks
Smitha

On Fri, Jul 10, 2015 at 10:59 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "David E. Wheeler" <david(at)justatheory(dot)com> writes:
> > My co-workers tell me that pg_upgrade told them to drop the colnames and
> > hostname extensions before upgrading from 9.3 to 9.4.
>
> Really? I see nothing in the source code that would print any such
> advice.
>
> There *is* a check on whether .so libraries used by the source
> installation exist in the destination one. But the preferred way to
> deal with that type of complaint is to install the needed libraries
> (in the destination's lib/ folder). You shouldn't have to drop anything
> as long as you have a copy of the extension that works for the new PG
> version.
>
> regards, tom lane
>

--
Smitha Pamujula
Database Administrator // The Watch Woman

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