Postgres Pro
Downloads
Home   >   mailing lists

Re: Enabling extensions on a compiled instance of postgresql 12.1 - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: Enabling extensions on a compiled instance of postgresql 12.1
Date
Msg-id 20200213134808.GA49910@nol
Whole thread Raw
In response to Enabling extensions on a compiled instance of postgresql 12.1  ("Sterpu Victor" <victor@caido.ro>)
Responses Re[2]: Enabling extensions on a compiled instance of postgresql 12.1  ("Sterpu Victor" <victor@caido.ro>)
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: "Sterpu Victor"
Date:
Subject: Enabling extensions on a compiled instance of postgresql 12.1
Next
From: "Sterpu Victor"
Date:
Subject: Re[2]: Enabling extensions on a compiled instance of postgresql 12.1