Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: enabling uuid-ossp in centos 7

Re: enabling uuid-ossp in centos 7

From
"sivapostgres@yahoo.com"
Date:
Hello,
Installed postgresql 11 in CentOS 7 through 

yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install postgresql11
yum install postgresql11-server
/usr/pgsql-11/bin/postgresql-11-setup initdb

Now the command
create extension if not exists "uuid-ossp";
gives the following error

could not open extension control file "/usr/pgsql-11/share/extension/uuid-ossp.control": No such file or directory
SQL state: 58P01

What to do to enable this extension?

In windows, this works fine.  Issue is when installing under Linux only.

Happiness Always
BKR Sivaprakash

Re: enabling uuid-ossp in centos 7

From
Laurenz Albe
Date:
On Mon, 2020-03-02 at 11:00 +0000, sivapostgres@yahoo.com wrote:
> yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
> yum install postgresql11
> yum install postgresql11-server
> /usr/pgsql-11/bin/postgresql-11-setup initdb
> 
> Now the command
> create extension if not exists "uuid-ossp";
> gives the following error
> 
> could not open extension control file "/usr/pgsql-11/share/extension/uuid-ossp.control": No such file or directory
> SQL state: 58P01
> 
> What to do to enable this extension?
> 
> In windows, this works fine.  Issue is when installing under Linux only.

You forgot

yum install postgresql11-contrib

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com