5

I created a box on Nitrous.io and installed postgres database using autoparts. Now I want to enable UUID so was trying to add the uuid-ossp extension when I run the command CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;

I get the following error ERROR: could not open extension control file "/home/action/.parts/packages/postgresql/9.2.4/share/postgresql/extension/uuid-ossp.control": No such file or directory

It appears like the uuid-ossp extension is not included with the postgres installation.

I thought if I can provide the required files it would work and I copied out the following files into the above folder - uuid-ossp--1.0.sql uuid-ossp--unpackaged--1.0.sql uuid-ossp.control

Now when I tried creating the extension I got a new error - ERROR: could not access file "$libdir/uuid-ossp": No such file or directory

Looks like I am missing something. Any help is appreciated.

Thanks

0 Answers0