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?