cloudfoundry/cf-release — pull request #392 by brahmaroutu (2014-05-19 21:50:43+00:00)
Title: adding postgres9 (9.3.4) as a job for migration

This pull request allows users to upgrade from postgres 9.0.3 to postgres 9.3.4. It uses psql sources available from their distribution to compile and deploy a postgres9 job with the same functionality as the original postgres job. For bosh-lite users postgres9.3.4(postgres9) is deployed in place of old postgres 9.0.3 job.
In order to deploy postgres9 we need to add blob "blobs/postgres9/postgresql-9.3.4.tar.gz" to your cf-release and then create the release.
For non-Bosh-lite environments, Postgres9 will be running as a separate job in the environment along with the old postgres 9.0.3. To switch to postgres9 simply change the the database settings to point to the ip address of the postgres9 server.
In case where migration is needed, a migration script is shipped with postgres9 job that can be run from the postgres9 server to migrate, for example ccdb and uaadb, databases.
Migration is not automatically run as it requires adminstrative decisions on when it is best to migrate and switch without leaving inconsistencies between the two Databases.

Pivotal should add postgresql-9.3.4.tar.gz to their blobs for deployments to run smoothly.
http://www.postgresql.org/ftp/source/v9.3.4/