| From: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
|---|---|
| To: | Smitha Pamujula <smitha(dot)pamujula(at)iovation(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Grant Holly <grant(dot)holly(at)iovation(dot)com> |
| Subject: | Re: pg_upgrade + Extensions |
| Date: | 2015-07-10 21:05:53 |
| Message-ID: | BD9D093A-7386-4ACB-B13D-301661BDBE69@justatheory.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Jul 10, 2015, at 11:32 AM, Smitha Pamujula <smitha(dot)pamujula(at)iovation(dot)com> wrote:
> 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.
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(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.
Best,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2015-07-10 21:06:01 | Re: Additional role attributes && superuser review |
| Previous Message | Tom Lane | 2015-07-10 20:43:22 | Re: PATCH: index-only scans with partial indexes |