Skip to content

postgres/15

You can find the source of this version on GitHub at cloudfoundry/postgres-release. It was created based on the commit 97b5bc8e.

Release Notes

PostgreSQL version upgrade

This release upgrades PostgreSQL to version 9.6.2. NOTE: this drops support for upgrading from PostgreSQL 9.4.5. Only upgrades from PostgreSQL 9.4.6 and 9.4.9 are supported.

Considerations before deploying: - A copy of the database is made for the upgrade, you may need to adjust the persistent disk capacity of the postgres job. - The upgrade happens as part of the monit start and its duration may vary basing on your env. The postgres monit start timeout can be adjusted using property databases.monit_timeout. You may need to specify a higher value if you have a large database. The pg_upgrade utility is used to upgrade. - Postgres will be unavailable during this upgrade.

Both old and new databases are kept. The old database is moved to /var/vcap/store/postgres/postgres-previous. The postgres-previous directory will be kept until the next postgres upgrade is performed in the future. You are free to remove this if you have verified the new database works and you want to reclaim the space.

In case of issues during the upgrade, refer to the Upgrading section of the README.

Job spec changes

The default value for the databases.monit_timeout has been changed to 90 seconds.

Usage

You can reference this release in your deployment manifest from the releases section:

- name: "postgres"
  version: "15"
  url: "https://bosh.io/d/github.com/cloudfoundry/postgres-release?v=15"
  sha1: "d66b3c4492ef84ad0fd93020de2377b1e203a427"

Or upload it to your director with the upload-release command:

bosh upload-release --sha1 d66b3c4492ef84ad0fd93020de2377b1e203a427 \
  "https://bosh.io/d/github.com/cloudfoundry/postgres-release?v=15"

Jobs

Packages