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.
Deployment
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>
Future work
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).
Read more
Release notes for postgresql-docker-boshrelease v4.
Spread the word
