It works.
Thank you, thank you, thank you.
------ Original Message ------
From: "Julien Rouhaud" <rjuju123@xxxxxxxxx>
To: "Sterpu Victor" <victor@xxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
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?
