BUG #15191: postgresql extension "uuid-ossp" Error

Started by PG Bug reporting formalmost 8 years ago3 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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

#2Michael Paquier
michael@paquier.xyz
In reply to: PG Bug reporting form (#1)
Re: BUG #15191: postgresql extension "uuid-ossp" Error

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

#3Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: Michael Paquier (#2)
Re: BUG #15191: postgresql extension "uuid-ossp" Error

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