Обсуждение: BUG #15191: postgresql extension "uuid-ossp" Error

The following bug has been logged on the website:

Bug reference:      15191
Logged by:          Bhaskar Choudari
Email address:      bhaskar@ramersoft.com
PostgreSQL version: 10.3
Operating system:   CentOS 7
Description:

test_db=# create extension "uuid-ossp";
ERROR:  could not open extension control file
"/usr/pgsql-10/share/extension/uuid-ossp.control": No such file or directory

On Wed, May 09, 2018 at 06:38:48AM +0000, PG Bug reporting form wrote:
> test_db=# create extension "uuid-ossp";
> ERROR:  could not open extension control file
> "/usr/pgsql-10/share/extension/uuid-ossp.control": No such file or directory

This is not a bug.  Usually on Linux all distributions split the core
server packages and the extra modules into two different packages, so
you are  visibly missing the extra one.  For CentOS 7, this is usually
named postgresql-contrib.  If you install that, then you will be able to
install the extension(s) you are looking for.
--
Michael

Hi,

On Wed, 2018-05-09 at 15:52 +0900, Michael Paquier wrote:
> For CentOS 7, this is usually
> named postgresql-contrib.  If you install that, then you will be able to
> install the extension(s) you are looking for.

In this case, it is postgresql10-contrib -- without the version number, it will
install 9.2 .

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR