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.

v14

No functional changes:

• fixed an issue that may occur while deploying a new postgres-release version

v13

No functional changes

v12

No functional changes

v11

No functional changes:

• Fixed failure in pre-start if pid file is empty
• Fixed failure in deploying on bosh-lite using generated manifest

v10

Changes:

• The postgres monit start timeout has been reduced. You can now use the optional property databases.monit_timeout to customize it. If not specified, the monit global timeout applies. You may need to specify a higher value if you have a large database and the postgres-release deployment includes a PostgreSQL upgrade.

v9

Changes:

• Improve PostgreSQL version upgrade procedure to consume less disk space. Note that as an effect of this change the PostgreSQL data directory has been moved from /var/vcap/store/postgres-9.4.9 to /var/vcap/store/postgres/postgres-9.4.9. details

v8

No functional changes.

v7

No functional changes.

v6

No functional changes.