I am trying to create uuid-ossp extension for my builds but these commands fail:
psql -d DATABASE -c 'CREATE EXTENSION "uuid-ossp";' CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;
CloudBees PostgreSQL binaries don’t have extensions found in contrib directory of PostgreSQL sources. You will need to build your own PostgreSQL binaries to use it.
You should find everything you need to compile PostgreSQL on CloudBees slaves.If you require a missing dependency to build your own binaries, you can build PostgreSQL on your own Linux server and upload the archive in your private repository. You should use a Fedora 17 x64 to prepare binaries.
Building your own PostreSQL binaries should only be done once. The generated archive should be put in your private DEV@cloud repository. Jobs requiring it would download and extract the archive like custom binaries we offer.