Enabling extensions on a compiled instance of postgresql 12.1

Поиск
Список
Период
Сортировка
От Sterpu Victor
Тема Enabling extensions on a compiled instance of postgresql 12.1
Дата
Msg-id em921ca1f1-31af-4936-9333-ebfa7c7664d8@victor-pc
обсуждение исходный текст
Ответы Re: Enabling extensions on a compiled instance of postgresql 12.1  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-general
Hello

I compiled from source postgresql 12.1 and all went fine but when I try to restore my DB I can see that I have 3 extensions missing: uuid-ossp, btree_gist, tablefunc.
I tried to run: CREATE EXTENSION "uuid-ossp"; and the error is ERROR:  could not open extension control file "/usr/local/pgsql_12.1/share/extension/uuid-ossp.control": No such file or directory
How do I enable these extensions? I tried to copy the file from my previous postgres version but is not compatible.
These were my compiling options:  ./configure --with-ossp-uuid --with-uuid=bsd --prefix=/usr/local/pgsql_12.1

Thank you.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tim Kane
Дата:
Сообщение: Re: Avoiding out of date statistics / planner
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Enabling extensions on a compiled instance of postgresql 12.1