PostgreSQL 9.5 is coming and includes many new features, including the new UPSERT command, and JSONB-modifying operators and functions. For operators of Cloud Foundry, we’ve pushed out a new service broker release that allows you to offer PostgreSQL 9.5 beta to some of your users, even before the final 9.5 release.
This service broker is a combination of Ferran Rodenas’ cf-containers-broker, and a BOSH release that pre-packages various versions of PostgreSQL in Docker images: postgresql-docker-boshrelease.
First upload the two BOSH releases to your BOSH:
bosh upload release https://bosh.io/d/github.com/cf-platform-eng/docker-boshrelease bosh upload release https://bosh.io/d/github.com/cloudfoundry-community/postgresql-docker-boshrelease
Next, read the appropriate installation/deployment instructions for your use case in the usage section.
When deploying the server broker you can generate a deployment manifest with a command like:
./templates/make_manifest warden container embedded
Deploy the server:
bosh -n deploy
To grow the cluster to allow multiple nodes, see the Subway project.
Register or update the registration of the service broker:
cf create-service-broker pg containers containers http://10.244.20.6
Finally, enable each of the different versions of PostgreSQL that you’d like to make available to your users:
cf enable-service-access postgresql95
To enable access to PostgreSQL to a limited set of organizations:
cf enable-service-access postgresql95 -o <org>
In future, this PostgreSQL service broker will natively support the Subway broker to easily allow the cluster of hosting machines to be scaled horizontally.
There is also some work on backups/restore beginning. See the [v4 release notes]((https://github.com/cloudfoundry-community/postgresql-docker-boshrelease/releases/tag/v4).
Backup/restore will be the core concept to allow users to self-upgrade from one database version to another (9.4 -> 9.5).
Release notes for postgresql-docker-boshrelease v4.