Re: pg_upgrade + Extensions

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: pg_upgrade + Extensions
Дата
Msg-id CAD5tBcLwmrSMt7nWOtuB_8TS+Z5uDRABik--X9fzbwJaH6rtSQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade + Extensions  ("David E. Wheeler" <david@justatheory.com>)
Ответы Re: pg_upgrade + Extensions  (Smitha Pamujula <smitha.pamujula@iovation.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Reusing abbreviated keys during second pass of ordered [set] aggregates
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Freeze avoidance of very large table.