v15

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.