Crunchy PostgreSQL for PCF Release Notes

This topic provides release notes for Crunchy PostgreSQL for Pivotal Cloud Foundry (PCF) Tile.

v04.090513.001

Release Date: May 11, 2018

Software features in this release:

  • [Software Component Update] - PostgreSQL Update from 9.5.12 to 9.5.13
    • This release contains a variety of fixes from 9.5.12. For a list of changes, please see https://www.postgresql.org/docs/9.5/static/release-9-5-13.html

      Note: Crunchy PostgreSQL for PCF can be directly upgraded from v3 to v4. Services using versions of Crunchy PostgreSQL for PCF prior to v3 should first upgrade to v3, then directly to v4 for maximum stability.

Note: Crunchy PostgreSQL for PCF v4 relies on functionality released in PCF v1.11 – v2.1 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v4.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and/or deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v04.090512.001

Release Date: April 27, 2018

Software features in this release:

  • [New Software Feature] - Compliance Profiles
    • Provide users with the option to produce audit logs that comply with ICS 500-27 requirements.
  • [New Software Feature] - Inspec
    • Implement tool to automate the verification of the DISA Security Technical Implementation.
  • [Software Component Update] - PGMonitor Update (v1.4 to v1.6)
  • [Software Component Update] - Pivotal On Demand Broker SDK (v0.17.0 to v0.18.0)
  • [Software Component Update] - Pivotal Stemcell (v3363 to v3468)
  • [Software Component Update] - Crunchy PostgreSQL On Demand Broker (v3 to v4)
    • Provide application owners ability to upgrade a service from a smaller to larger size.
    • Enhance acceptance tests
  • [Software Component Update] - Crunchy PostgreSQL Service Adapter (v3 to v4)
    • Redesign of service adapter allowing for increased system compatibility and additional features.
  • [Software Component Update] - Crunchy PostgreSQL BOSH Release (v3 to v4)
    • Monitoring system now reports statistics on all PostgreSQL instances available in the cluster.
    • Remove smoke-test errand and introduce the post-deploy errand.
    • Provide option for operators to customize the log rotation settings.
    • Fix issue preventing log rotation because of incorrect permissions.
    • Fix issue preventing the Redis Foreign Data Wrapper from being created.
    • Fix issue preventing the upgrade-all-service-instances errand from completing by causing fail-overs to occur during the upgrade errand.
    • Fix issue preventing a replica from being restored to service if more than one replica was down.
    • Fix issue preventing PGMonitor from reporting all data items.
    • Fix issue preventing updates to the monitoring database when a new instance is created and a failover occurs on the original instance.
    • Fix issue causing timeout failure during service creation when running the monitoring installation on a replica.
    • Fix issue causing the PGAudit extension to be installed even if the option was specified to be false.
  • [Support Update] - Crunchy PostgreSQL for PCF is supported in PCF 2.1.
  • [New Configuration Option] - Bloat Check Schedule
    • Allow the service user to set the schedule for the bloat check statistics.
  • [New Configuration Option] - Logging Parameters
    • Allows the operator to configure the logging rotation size, age and filename.
  • [Security Update] - Implementation of MD5 password authentication for the monitoring user.
  • [Security Update] - Implementation of dynamic PGBackRest SSH keys to allow for dynamic role changes.

Note: Crunchy PostgreSQL for PCF can be directly upgraded from v3 to v4. Services using versions of Crunchy PostgreSQL for PCF prior to v3 should first upgrade to v3, then directly to v4 for maximum stability.

Note: Crunchy PostgreSQL for PCF v4 relies on functionality released in PCF v1.11 – v2.1 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v4.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and/or deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090512.109

Release Date: March 6, 2018

Software features in this release:

  • PostgreSQL minor release: 9.5.12
    • This minor release addresses CVE-2018-1058: Uncontrolled search path element in pg_dump and other client applications

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090511.108

Release Date: February 15, 2018

Software features in this release:

  • PostgreSQL minor release: 9.5.11
  • Component update: pgBackrest (1.25 to 1.28)
  • Component update: node_exporter (0.15.1 to 0.15.2)
  • Support for customizing bloat check schedule
  • Bugfix: Health check error may cause unnecessary failovers
  • Bugfix: Prometheus series errors from fast failover

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090510.107

Release Date: January 25, 2018

Software features in this release:

  • PostgreSQL minor release: 9.5.10
  • Added ‘Monitoring’ feature: using Grafana and Prometheus
  • Support for PostgreSQL Foreign Data Wrapper
  • Support for Redis Foreign Data Wrapper
  • Support for optionally enabling PL/R extensions
  • Support for additional PostgreSQL configuration options

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090510.106

Release Date: November 9, 2017

Software features in this release:

  • PostgreSQL minor release: 9.5.10
  • Component upgrade: PG common 184 to 187
  • Component upgrade: Backrest 1.20 to 1.25
  • Component upgrade: pgaudit_analyze 1.0.6 to 1.0.7
  • Fixed bug with SSH known hosts causing backrest failures
  • Fixed bug where replicas reported failing to BOSH
  • Tuned failover code to fence failed primaries

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090509.105

Release Date: September 15, 2017

Software features in this release:

  • Upgrade ODB SDK from 0.14.1 -> 0.17.0
  • Added service quotas for plans
  • Added configurable replica counts

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090509.104

Release Date: August 31, 2017

New tags included in this release:

  • PostgreSQL 9.5.9

Software fixes in this release:

  • Fixed bug where monit triggered PostgreSQL to restart
  • Fixed bug where failover didn’t repair fenced servers

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090508.103

Release Date: August 16, 2017

Security fixes included in this release:

  • Update stemcell to patch Ubuntu Linux kernel security vulnerability (USN-3385-2)

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090508.102

Release Date: August 14, 2017

Security fixes included in this release:

  • Security Vulnerability CVE-2017-7546: Empty password accepted in some authentication methods
  • Security Vulnerability CVE-2017-7547: The “pg_user_mappings” catalog view discloses passwords to users lacking server privileges
  • Security Vulnerability CVE-2017-7548: lo_put() function ignores ACLs

New tags included in this release:

  • PostgreSQL 9.5.8
  • PostGIS 2.3.3
  • PgAudit 1.0.6
  • pgBackrest 1.20
  • PLR 8.3.0.17

Software fixes in this release:

  • Fixed slow deprovision bug
  • Added primary to replica pool as a fallback for read queries
  • Added hourly job to repair fenced services
  • Fixed bug where HAProxy would not disconnect users after failover
  • Lifted replica limitation
  • Improved healthchecks for PostgreSQL

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090507.101

Release Date: July 14, 2017

Security fixes included in this release:

  • Prevent the tile from logging manifests generated by the broker when deploying PostgreSQL, because they contain sensitive information.

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v03.090507.100

Release Date: July 1, 2017

WARNING: This is the GA release, and is not compatible with the previous releases, including the beta release. Please see detailed release notes below for more information.

Features included in this release (for details on features please read the feature-overview document):

  • High-availability model
  • Auto-failover
  • On-Demand single-tenant service

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v02.090507.101

Release Date: May 23, 2017

WARNING: This is an updated beta release of the on-demand single-tenant service. This beta release is intended for evaluation purposes only. The final release of this software will include some changes that will likely break compatibility between this release and the next release.

Features included in this release (for details on features please read the feature-overview document):

  • On-Demand single-tenant service

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v02.090507.100

Release Date: May 12, 2017

WARNING: This is a beta release of the on-demand single-tenant service. This beta release is intended for evaluation purposes only. The final release of this software will include some changes that will likely break compatibility between this release and the next release.

Features included in this release:

  • On-Demand single-tenant service

Note: Crunchy PostgreSQL for PCF v3 relies on functionality released in PCF v1.9 – v2.0 to provide support for “on-demand broker” capability.

To implement this functionality, Crunchy Data has made material modifications to the Crunchy PostgreSQL for PCF manifest and does not currently provide a direct upgrade path from Crunchy PostgreSQL for PCF v1 or v2 to Crunchy PostgreSQL for PCF v3.

To avoid confusion between the two implementations, Crunchy Data has removed the Crunchy PostgreSQL for PCF v1 and v2 software versions from Pivotal Network. If you previously downloaded and deployed an evaluation copy of Crunchy PostgreSQL for PCF v1 or v2, Crunchy Data is happy to provide ongoing commercial subscription support.

If you are interested in commercial subscription support for Crunchy PostgreSQL for PCF, please contact sales@crunchydata.com.

v1.0.8

Release Date: March 10, 2017

Features included in this release:

  • Crunchy PostgreSQL v9.5 and PostGIS v2.3
  • Leader/follower PostgreSQL architecture
  • Load-balanced read replicas
  • Load-balanced brokers
  • Automated backups with pgBackrest
  • Self-managed databases

v1.0.6

Release Date: January 13, 2017

Features included in this release:

  • Crunchy PostgreSQL v9.5 and PostGIS v2.2
  • Leader/follower PostgreSQL architecture
  • Load-balanced read replicas
  • Load-balanced brokers
  • Automated backups with pgBackrest
  • Self-managed databases
Create a pull request or raise an issue on the source for this page in GitHub