Thread

1. compiling postgresql with uuid-ossp failure

   Ibrahim Shaame <ishaame@gmail.com> — 2019-02-28T08:33:28Z

   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
   

2. Re: compiling postgresql with uuid-ossp failure

   Ibrahim Shaame <ishaame@gmail.com> — 2019-02-28T08:35:54Z

   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
   >
   

3. Re: compiling postgresql with uuid-ossp failure

   Tom Lane <tgl@sss.pgh.pa.us> — 2019-02-28T16:57:57Z

   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