You can find the source of this version on GitHub at cloudfoundry/postgres-release. It was created based on the commit
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
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.
You can reference this release in your deployment manifest from the
- 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
bosh upload-release --sha1 d66b3c4492ef84ad0fd93020de2377b1e203a427 \ https://bosh.io/d/github.com/cloudfoundry/postgres-release?v=15