Enabling extensions on a compiled instance of postgresql 12.1

Started by Sterpu Victorabout 6 years ago3 messagesgeneral
Jump to latest
#1Sterpu Victor
victor@caido.ro

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.

#2Julien Rouhaud
rjuju123@gmail.com
In reply to: Sterpu Victor (#1)
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?

#3Sterpu Victor
victor@caido.ro
In reply to: Julien Rouhaud (#2)
Re[2]: Enabling extensions on a compiled instance of postgresql 12.1

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

Show quoted text

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?