Thread: compiling postgresql with uuid-ossp failure
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)
------------+-----------------+-------------------+-------------------------------------------
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
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 ICREATE 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
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