Thread: compiling postgresql with uuid-ossp failure

compiling postgresql with uuid-ossp failure

From
Ibrahim Shaame
Date:
I have installed idempiere ERP which requires uuid-ossp library. I have tried to recompile postgresql-11.2 with the option --with-uuid=ossp. When run I
CREATE EXTENSION "uuid-ossp";
I get the following error:
ERROR:  could not open extension control file "/data/databases/postgres/pgsql11/share/extension/uuid-ossp.control": No such file or directory.

 select * from pg_available_extensions;
gives me this list  (without uuid-ossp, of course):

 name    | default_version | installed_version |                  comment                 
------------+-----------------+-------------------+-------------------------------------------
 pltclu     | 1.0             |                   | PL/TclU untrusted procedural language
 pltcl      | 1.0             |                   | PL/Tcl procedural language
 plperl     | 1.0             |                   | PL/Perl procedural language
 plperlu    | 1.0             |                   | PL/PerlU untrusted procedural language
 plpythonu  | 1.0             |                   | PL/PythonU untrusted procedural language
 plpython2u | 1.0             |                   | PL/Python2U untrusted procedural language
 plpgsql    | 1.0             | 1.0               | PL/pgSQL procedural language
(7 rows)



 Is there a reason why this extension was not created during compilation/installation?

Thanks

Re: compiling postgresql with uuid-ossp failure

From
Ibrahim Shaame
Date:
Sorry: My system is:
Linux
Slackware64-Current
Postgresql-11.2


On Thu, Feb 28, 2019 at 9:33 AM Ibrahim Shaame <ishaame@gmail.com> wrote:
I have installed idempiere ERP which requires uuid-ossp library. I have tried to recompile postgresql-11.2 with the option --with-uuid=ossp. When run I
CREATE EXTENSION "uuid-ossp";
I get the following error:
ERROR:  could not open extension control file "/data/databases/postgres/pgsql11/share/extension/uuid-ossp.control": No such file or directory.

 select * from pg_available_extensions;
gives me this list  (without uuid-ossp, of course):

 name    | default_version | installed_version |                  comment                 
------------+-----------------+-------------------+-------------------------------------------
 pltclu     | 1.0             |                   | PL/TclU untrusted procedural language
 pltcl      | 1.0             |                   | PL/Tcl procedural language
 plperl     | 1.0             |                   | PL/Perl procedural language
 plperlu    | 1.0             |                   | PL/PerlU untrusted procedural language
 plpythonu  | 1.0             |                   | PL/PythonU untrusted procedural language
 plpython2u | 1.0             |                   | PL/Python2U untrusted procedural language
 plpgsql    | 1.0             | 1.0               | PL/pgSQL procedural language
(7 rows)



 Is there a reason why this extension was not created during compilation/installation?

Thanks

Re: compiling postgresql with uuid-ossp failure

From
Tom Lane
Date:
Ibrahim Shaame <ishaame@gmail.com> writes:
> I have installed idempiere ERP which requires uuid-ossp library. I have
> tried to recompile postgresql-11.2 with the option --with-uuid=ossp.

That option doesn't in itself cause any contrib modules to be built
or installed ...

> I get the following error:
> ERROR:  could not open extension control file
> "/data/databases/postgres/pgsql11/share/extension/uuid-ossp.control": No
> such file or directory.

... and you evidently don't have uuid-ossp installed.  You need to do
"make ; make install" in either contrib/uuid-ossp, or the parent
contrib directory if you want all the contrib extensions.

            regards, tom lane