Re: pg_upgrade + Extensions

Поиск

Список

Период

Сортировка

От	Smitha Pamujula
Тема	Re: pg_upgrade + Extensions
Дата	13 июля 2015 г. 20:12:25
Msg-id	CAGWGGXNuBOifpqMK0GHESfZJbsoFMWRzYBm-FPskMf9Wd=SHzA@mail.gmail.com обсуждение исходный текст
Ответ на	Re: pg_upgrade + Extensions (Andrew Dunstan <andrew@dunslane.net>)
Ответы	Re: pg_upgrade + Extensions (Andrew Dunstan <andrew@dunslane.net>)
Список	pgsql-hackers

Дерево обсуждения

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@dunslane.net> wrote:

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