Re: enabling uuid-ossp in centos 7
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 commandcreate 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 directorySQL state: 58P01
What to do to enable this extension?
In windows, this works fine. Issue is when installing under Linux only.
Happiness AlwaysBKR Sivaprakash
Import Notes
Reference msg id not found: 576790916.4465797.1583146838375.ref@mail.yahoo.com
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 initdbNow the command
create extension if not exists "uuid-ossp";
gives the following errorcould not open extension control file "/usr/pgsql-11/share/extension/uuid-ossp.control": No such file or directory
SQL state: 58P01What 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