Обсуждение: Enabling extensions on a compiled instance of postgresql 12.1

On Thu, Feb 13, 2020 at 01:34:55PM +0000, Sterpu Victor wrote:
> 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

Did you also do a "make install" under the contrib/ directory?

It works.
Thank you, thank you, thank you.

------ Original Message ------
From: "Julien Rouhaud" <rjuju123@gmail.com>
To: "Sterpu Victor" <victor@caido.ro>
Cc: pgsql-general@postgresql.org
Sent: 2020-02-13 3:48:08 PM
Subject: Re: Enabling extensions on a compiled instance of postgresql
12.1

>On Thu, Feb 13, 2020 at 01:34:55PM +0000, Sterpu Victor wrote:
>>  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
>
>Did you also do a "make install" under the contrib/ directory?