How do I install/enable the uuid-ossp extension on Postgres 9.3?

Question

I’m using Postgres 9.3 on Ubuntu Linux 14.04. How do I install/enable the uuid-ossp extension? I first verified the contrib package was installed …

root@prodbox:/home/rails/myproject# apt-get install postgresql-contrib Reading package lists... Done Building dependency tree Reading state information... Done postgresql-contrib is already the newest version.
and then I logged in and tried to create the extension …

root@prodbox:/home/rails/myproject# su - postgres postgres@prodbox:~$ psql psql (9.6.0, server 9.3.11) Type "help" for help. postgres=# CREATE EXTENSION "uuid-ossp"; ERROR: could not open extension control file "/usr/share/postgresql/9.3/extension/uuid-ossp.control": No such file or directory

I’m all out of ideas. What am I missing?

Ella Clarkson · Accepted Answer

These steps worked for me in my centos 7, when I was facing this issue in my postgres 12, sudo yum install postgresql-contrib-12 sudo su - postgres or whatever your username for postgres is psql to enter into postgresql cli commands line CREATE EXTENSION "uuid-ossp";

How do I install/enable the uuid-ossp extension on Postgres 9.3?

About this question

Your answer

1 Answer

More Salesforce discussions

Learn & Explore

Salesforce Tutorials

Salesforce Interview Q&A

Latest Salesforce Blogs

Want answers to more Salesforce questions?

Stay in the loop — it’s free

You’re on the list!