PostgreSQL 9.5 Tile Release Notes
This topic provides release notes for Crunchy PostgreSQL for Pivotal Cloud Foundry (PCF) Tile.
v05.9525.013
Release Date: March 05, 2021
Notable software features in this release:
- [Software Component Update] PostgreSQL v9.5.24-1 updated to v9.5.25-1
- [Software Component Update] Support Software Updates
- postgres-common 222 -> 225
- PgAudit 1.0.7 -> 1.0.8
- Crunchy Backrest 2.27 -> 2.32
- mysql common / mysql client 5.7.32 -> 5.7.33
- libjasper1: 1.900.1-debian1-2.4ubuntu1.2 -> 1.900.1-debian1-2.4ubuntu1.3
- libpoppler58: 0.41.0-0ubuntu1.14 -> 0.41.0-0ubuntu1.16
- libssl1.0.0: 1.0.2g-1ubuntu4.17 -> 1.0.2g-1ubuntu4.18
v05.9524.012
Release Date: December 01, 2020
Notable software features in this release:
- [Software Component Update] PostgreSQL v9.5.23-1 updated to v9.5.24-1
- [Software Component Update] Support Software Updates
- postgres-common 215 -> 222
- consul 1.7.2 -> 1.7.9
- consul-template 0.20.0 -> 0.22.1
- mysql common / mysql client 5.7.31 -> 5.7.32
- libdbi-perl_1.634-1build1 -> libdbi-perl_1.634-1ubuntu0.2
- libopenjp2-7_2.1.2-1.1+deb9u3build0.16.04.1 -> libopenjp2-7_2.1.2-1.1+deb9u5build0.16.04.1
- libssl1.0.0_1.0.2g-1ubuntu4.16 -> libssl1.0.0_1.0.2g-1ubuntu4.17
- libsystemd-dev_229-4ubuntu21.28 -> libsystemd-dev_229-4ubuntu21.29
Additional notes about this release:
- This release addresses critical vulnerabilities in PostgresSQL. This upgrade is strongly recommended. Further information on these CVEs are available here: CVE-2020-25694 CVE-2020-25695 CVE-2020-25696
v05.9523.011
Release Date: September 10, 2020
Notable software features in this release:
- [New Software Feature] Configure S3 URI Style, defaults to host-based URIs
- [New Software Feature] Enable/Disable certificate verification of SSL/TLS S3 connections
v05.9523.010
Release Date: August 31, 2020
Notable software features in this release:
- [Software Component Update] PostgreSQL v9.5.22-1 updated to v9.5.23-1
- [Software Component Update] Support Software Updates
- postgres-common 214 -> 215
- pgbackrest 2.15.1 -> 2.27
- ODB-SDK 0.24.0 -> 0.39.0
- mysql common / mysql client 5.7.30 -> 5.7.31
- libc 2.23-0ubuntu10 -> 2.23-0ubuntu11.2
- libjpeg-turbo 1.4.2-0ubuntu3.3 -> 1.4.2-0ubuntu3.4
- libssl 1.0.2g-1ubuntu4.15 -> 1.0.2g-1ubuntu4.16
v05.9522.009
Release Date: May 29, 2020
Notable software features in this release:
- [Software Component Update] PostgreSQL v9.5.21-1 updated to v9.5.22-1
- [Software Component Update] Pivotal Stemcell (170.x to 621.x)
- [Software Component Update] Support Software Updates
- postgres-common 211 -> 214
- python-certifi 2019.6.16 -> 2020.4.5.1
- python-click 7.0 -> 7.1.2
- python-configparser 3.7.4 -> 3.8.1
- python-flask 1.0.3 -> 1.1.2
- python-flask-httpauth 3.3.0 -> 4.0.0
- python-idna 2.8 -> 2.9
- python-jinja 2.11.1 -> 2.11.2
- python-psycopg2 2.7.7 -> 2.8.5
- python-requests 2.22.0 -> 2.23.0
- python-urllib3 1.25.3 -> 1.25.9
- python-werkzeug 0.15.4 -> 1.0.1
- node-exporter 0.17.0 -> 0.18.1
- consul 1.4.4 -> 1.7.2
- cf_cli 6.49.0 -> 6.51.0
- pgloader 3.6.1 -> 3.6.2
- postgres-exporter 0.4.7 -> 0.8.0
- wal2json 1.0 to 2.2
- bosh CLI 5.1.2 -> 6.2.1
- prometheus 2.13.0 -> 2.17.2
- mysql common / mysql client 5.7.29 -> 5.7.30
- libsystemd-dev 229-4ubuntu21.27 -> 229-4ubuntu21.28
v05.9521.008
Release Date: Feb 25, 2020
Notable software features in this release:
- [Software Component Update] PostgreSQL v9.5.20-1 updated to v9.5.21-1
- [Software Component Update] Support Software Updates
- postgres-common 210 -> 211
- libjpeg-turbo 1.4.2-0ubuntu3.1 -> 1.4.2-0ubuntu3.3
- libmysqlclient 5.7.27-0ubuntu0.16.04.1 -> 5.7.29-0ubuntu0.16.04.1
- libsystemd-dev 229-4ubuntu21.22 -> 229-4ubuntu21.27
- mysql-common 5.7.27-0ubuntu0.16.04.1 -> 5.7.29-0ubuntu0.16.04.1
- python-jinja2 2.10.3 -> 2.11.1
v05.9520.007
Release Date: Dec 18, 2019
Notable software features in this release:
- [Software Component Update] PostgreSQL v9.5.19-1 updated to v9.5.20-1
- [Software Component Update] Support Software Updates
- postgres-common 204 -> 210
- pgaudit95 1.0.7-0 -> 1.0.7-1
- pgaudit10 1.2.1-0 -> 1.2.1-1
- pgaudit11 1.3.1-0 -> 1.3.1-1
- pgaudit_analyze 1.0.7-3 -> 1.0.7-4
- set_user 1.6.2-0 -> 1.6.2-1
- node_exporter 0.17.0-0 -> 0.17.0-1
- postgres_exporter 0.4.7-0 -> 0.4.7-1
- prometheus 2.7.1-0 -> 2.13.0-0
- python_jinja2 2.8.1 -> 2.10.3
- consul 1.4.4-0 -> 1.4.4-1
- consul_template 0.20.0-0 -> 0.20.0-1
- cf_cli 6.32.0-0 -> 6.32.0-1
- haproxy 1.6.3-1ubuntu0.2 -> 1.6.3-1ubuntu0.3
- libtiff5 4.0.6-1ubuntu0.6 -> 4.0.6-1ubuntu0.7
- libgif7 5.1.4-0.3~16.04 -> 5.1.4-0.3~16.04.1
- libgfortran 5.4.0-6ubuntu1~16.04.11 -> 5.4.0-6ubuntu1~16.04.12
v05.090519.006
Release Date: Aug 13, 2019
Notable software features in this release:
- [Software Component Update] PostgreSQL v9.5.18-1 updated to v9.5.19-1
- [Software Component Update] Consul Template structure updated.
- [Bug Fix] Resolved consul-template pre-start overwriting issues.
- [Software Component Update] Support Software Updates
- postgresql-common 201 -> 204
- libmysqlclient 5.7.26 -> 5.7.27
- libpoppler 0.41.0-0ubuntu1.11 -> 0.41.0-0ubuntu1.12
- libsystemd-dev 229-4ubuntu21.15 -> 229-4ubuntu21.22
- mysql-common 5.7.26 -> 5.7.27
- pgbackrest 2.14 -> 2.15.1
v05.090518.005
Release Date: Jun 21, 2019
Notable software features in this release:
- [New Software Feature] Secure TCP/IP Service Instance Connections via SSL
- [New Software Feature] Support for Loggregator Metrics
- [Software Component Update] Simplified instance creation, changed all previously
mandatory parameters to optional. Services can be created without any extra parameters.
- Database names, if not provided, will be generated programmatically at service creation time.
- [Software Feature Update] Added support for specifying a third-party S3 endpoint for S3 PGBackRest.
- [Software Component Update] PostgreSQL v9.5.16-1 updated to v9.5.18-1
- [Software Component Update] Major restructure and update to documentation.
- [Software Component Update] Support Software Updates
- consul 0.6.4 to 1.4.4
- consul-template 0.16.0 to 0.20.0
- libmysqlclient 5.7.25 to 5.7.26
- libopenjp2-7 2.1.2-1.1+deb9u2build0.1 to 2.1.2-1.1+deb9u3build0.16.04.1
- pgbackrest 2.07-1 to 2.14-2
- pgaudit95 1.0.6 to 1.0.7
- pgaudit-set-user 1.6.1 to 1.6.2
- plr 8.3.0.17 to 8.3.0.18
- postgres-common 199 to 201
- postgresql 9.5.16 to 9.5.18
- postgresql 10.7 to 10.9
- python-certifi 2018.11.29 to 2019.06.16
- python-configparser 3.5.0 to 3.7.4
- python-flask 1.0.2 to 1.0.3
- python-flask-oauthlib 0.9.4 to 0.9.5
- python-httpauth v3.2.4 to v3.3.0
- python-markupsafe 1.1.0 to 1.1.1
- python-oauthlib-version 2.0.2 to 3.0.1
- python-requests 2.21.0 to 2.22.0
- python-requests-oauthlib 0.8.0 to 1.2.0
- python-urllib3 1.24.1 to 1.25.3
- python-werkzeug 0.14.1 to 0.15.4
- wal2json 1.0-4 to 1.0-5
- [Software Component Update] New Software Dependencies
- mysql-common 5.7.26
- postgis25 2.5.0
v05.090516.003
Release Date: February 20, 2019
Notable software features in this release:
- [New Software Feature] Support for Ubuntu Xenial Stemcell
- [New Software Feature] PGBackrest and PostgreSQL archiving to S3
- [New Software Feature] Application level access to PostgreSQL statistics
- [Software Feature Update] Updated postgres-exporter queries
- [Software Feature Update] Improved Grafana integration
- [Software Component Update] PostgreSQL v9.5.15-1 updated to v9.5.16-1
- [Software Component Update] inspec 1.31.1-1 updated to 3.3.14-1
- [Software Component Update] wal2json 1.0-3 updated to 1.0-4
- [Software Component Update] postgresql common 198 updated to 199
- [Software Component Update] prometheus 2.2.1 updated to 2.7.1
- [Software Component Update] psycopg 2.7.6.1 updated to 2.7.7
- [Software Component Update] postgis 2.4.4-1 updated to 2.4.4-4
- [Software Component Update] r-base-core 3.0.2-1 updated to 3.2.3-4
- [Software Component Update] Python Updates
- Initial conversion to full Python 3 support
- python-openssl 0.13-2 to python3-openssl 0.15.1-2
- python-pkg-resources 3.3-1 to python3-pkg-resources 20.7.0-1
- python-yaml 3.10-4 to python3-yaml 3.11-3
- [Software Component Update] Support Software updates
- gdal 1.10.1 to 1.11.3
- libarmadillo4 253a4.200.0+Bdfsg-1 to libarmadillo6 3a6.500.5+dfsg-1
- libarpack2 3.1.5-2 to 3.3.0-1
- libblas3 1.2.20110419-7 to 3.6.0-2
- libc6 (and -dev) 2.19-0 to 2.23-0
- libdap11 3.12.0-1 to libdap17v5 3.15.1-7
- libdapclient3 3.12.0-1 to libdapclient6v5 3.15.1-7
- libdbd-pg-perl 2.19.3-2 to 3.5.3-1
- libdbi-perl 1.630-1 to 1.634-1
- libepsilon1 0.9.2-2 to 0.9.2-3
- libfontconfig1 2.11.0-0 to 2.11.94-0
- libgfortran3 4.8.4-2 to 5.4.0-6
- libgif4 4.1.6-11 to libgif7 5.1.4-0.3
- libhdf4-0-alt 4.2r10-0 to 4.2.10-3.2
- libhdf5-7 1.8.11-5 to libhdf5-10 1.8.16+docs-4
- libhiredis-dev 0.11.0-3 to 0.13.3-2
- libhiredis0.10 0.11.0-3 to libhiredis0.13 0.13.3-2
- libio-socket-inet6-perl 2.71-1 to 2.72-2
- libio-socket-ssl-perl 1.965-1 to 2.024-1
- libjasper1 1.900.1-14 to 1.900.1-debian1-2.4
- libjbig0 2.0-2ubuntu4.1 to 2.1-3.1
- libjpeg-turbo8 1.3.0-0 to 1.4.2-0
- libjs-jquery 1.7.2 to 1.11.3
- libkml0 1.3.0~r864-2 to libkmlbase1 1.3.0-1
- liblapack3 3.5.0-2 to 3.6.0-2
- liblcms2-2 2.5-0 to 2.6-3
- libltdl7 2.4.2-1.7 to 2.4.6-0.1
- liblwp-protocol-https-perl 6.04-2 to 6.06-2
- libmailtools-perl 2.12-1 to 2.13-1
- libmysqlclient18 5.5.54-0 to libmysqlclient20 5.7.25-0
- libnet-libidn-perl 0.12.ds-1 to 0.12.ds-2
- libnet-smtp-ssl-perl 1.01-3 to 1.03-1
- libnet-ssleay-perl 1.58-1 to 1.72-1
- libnetcdfc7 1%253a4.1.3-7 to libnetcdf11 1%3a4.4.0-2
- libodbc1 2.2.14p2-5 to 2.3.1-4.1
- libogdi3.2 3.2.0~beta2-7 to 3.2.0~beta2-7.1
- libonig2 5.9.6-1
- libpoppler44 0.24.5-2 to libpoppler58 0.41.0-0
- libproj0 4.8.0-2 to libproj9 4.9.2-2
- libprotobuf-c1 1.2.1-1
- libprotobuf9v5 2.6.1-1.3
- libssl1.0.0 1.0.1f-1 to 1.0.2g-1
- libsystemd-daemon0 204-5 to libsystemd-dev 229-4
- libtiff5 4.0.3-7 to 4.0.6-1
- liburiparser1 0.7.5-1 to 0.8.4-1
- libwebp5 0.4.0-4 to 0.4.4-1
- libwww-perl 6.05-2 to 6.15-1
- libxerces-c3.1 3.1.1-5.1 to 3.1.3
- libxml-libxml-perl 2.0108+dfsg-1 to 2.0123+dfsg-1
- libxml-parser-perl 2.41-1 to 2.44-1
- node_exporter v0.16.0 to v0.17.0
- odbcinst1debian2 2.2.14p2-5 to 2.3.1-4.1
- stdeb 0.6.0 to 0.8.5
v05.090515.003
Release Date: December 7, 2018
Notable software features in this release:
- [Software Component Update] PostgreSQL v9.5.15-1 to v9.5.15-2
- [Software Component Update] postgres-exporter v0.4.5 to v0.4.7
- [Software Component Update] python-psycopg2 v2.7.5 to v2.7.6.1
- [Software Component Update] python-requests v2.20.0 to v2.20.1
- [Software Component Update] ODB SDK v0.21.2 to v0.24.0
Additional notes about this release:
- This release addresses a critical vulnerability in the ODB SDK. This upgrade is strongly recommended. Further information on this CVE is available here: https://pivotal.io/security/cve-2018-15759
v05.090515.002
Release Date: November 12, 2018
Notable software features in this release:
- [Software Component Update] Improved failover selection
- [Stability Enhancement] Resolve issue with disk health reporting on instances using over 80% disk
- [New Software Feature] Allow for end-user specified PostgreSQL Extension installation
- [New Software Feature] Allow for end-user specified PostgreSQL settings configuration
- [New Software Feature] Support for SCRAM-SHA-256 Authentication
- SCRAM-SHA-256 Authentication is enabled and used by default on all new service instances as of this release
- A service configuration parameter has been added to allow for per-instance override to fall back to MD5 authentication
- MD5 Authentication is considered deprecated, and may be removed in a future release.
- [New Software Feature] New parameter added for enabling PostgreSQL syslog logging
- [New Plan Structure] BOSH Errand upgrade-all-service-instances now requires a Crunchy Data provided Upgrade Token
- [New Software Feature] Support for isolated networks, all support packages provided as part of this release
- [Software Component Update] PGBackRest v2.04-2 to v2.06-1
- [Software Component Update] PostgreSQL v9.5.14 to v9.5.15
- [Software Component Update] node_exporter v0.15.2 to v0.16.0
- [Software Component Update] python_certifi v2018.1.18 to v2018.10.15
- [Software Component Update] python_click v6.7 to v7.0
- [Software Component Update] python_itsdangerous v0.24 to v1.1.0
- [Software Component Update] python_requests v2.19.1 to v2.20.0
- [Software Component Update] python_urllib3 v1.23 to v1.24
- [Software Component Update] wal2json v1.0-2 to v1.0-3
v05.090514.001
Release Date: August 14, 2018
Notable software features in this release:
- [New Plan Structure] Addition of the general and standalone plans
- The small, med, large, and extra large plans have been removed in favor of using a general, custom, custom-monitor, general-monitor, standalone, and standalone-replica plans
- [New Service Offering] Standalone and Standalone Replica Services
- The standalone and standalone replica service offerings provide a single PostgreSQL instance with local pgBackRest that can either function independently or connect to a parent cluster for replication.
- A new configuration option for a standalone service instance, standalone_backups, that can be set to true to turn on local pgBackRest backups.
- The
standalone-replica
plan can connect across foundations provided the two service networks have connectivity.
- [Software Component Update] PGBackrest (v1.X to 2.04)
- [Software Component Update] Pivotal On Demand Broker SDK (v0.18.0 to v0.21.2)
- [Software Component Update] Pivotal Stemcell (3468 to 3541)
- [Software Component Update] Crunchy PostgreSQL On Demand Broker
version 05
- Enhanced acceptance tests
- [Software Component Update] Crunchy PostgreSQL Service Adapter
version 05
- Addition of a remote replication service key creation.
- Allows users to upgrade a standalone instance to a full cluster instance.
- Fixes a bug that caused configuration options to reset when new parameters were passed in to the service instance.
- [Software Component Update] Crunchy PostgreSQL BOSH version 05
- This new software version provides the updated service offerings, plan restructure, and remote replication.
- Fixes a bug that caused services instances to no longer be able to bind/unbind with applications.
- Fixes a bug that caused servers to not recover when rebooted outside the scope of BOSH.
- Fixes a bug that caused health check failures during heavy PostgreSQL transaction load times.
- Fixes a bug that caused multiple HAProxy process to remain active after receiving a kill command.
- [Software Component Update] Python Updates
- python-flask version 1.0.2
- python-flask-httpauth version 3.2.4
- python-idna version 2.7
- python-psycopg2 version 2.7.5
- python-requests version 2.19.1
- python-urllib3 version 1.23
- [Software Component Update] pgaudit-set-user version 1.6.1
- [New Software Feature]
wal2json
library availability - [New Software Feature] pgc_ configuration parameters can now be
updated through
update-service
- [New Configuration Option] Parallel upgrades for service instances
- [New Configuration Option] Standalone configurations:
- Option for backups by default
- Customizable VM type, persistent storage, connection limit
- [Stability Enhancemnet] Improves recovery from IaaS storage disconnection
Crunchy PostgreSQL for PCF can be directly upgraded from v4 to v5. Services using versions of Crunchy PostgreSQL for PCF prior to v3 should first upgrade to v4, then directly to v5 for maximum stability.
v04.090513.001
Release Date: May 11, 2018
Notable software features in this release:
- [Software Component Update] - PostgreSQL Update from v9.5.12 to
v9.5.13
- This release contains a variety of fixes from v9.5.12. For a list of changes, see the PostgreSQL v9.5.13 release notes.
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.
Crunchy PostgreSQL for PCF v4 relies on functionality released in PCF v1.11 through 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, contact sales@crunchydata.com.
v04.090512.001
Release Date: April 27, 2018
Notable 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 v2.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.
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.
Crunchy PostgreSQL for PCF v4 relies on functionality released in PCF v1.11 through 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, contact sales@crunchydata.com.
v03.090512.109
Release Date: March 6, 2018
Notable software features in this release:
- PostgreSQL minor release: v9.5.12
- This minor release addresses CVE-2018-1058: Uncontrolled search path element in pg_dump and other client applications
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
Notable software features in this release:
- PostgreSQL minor release: v9.5.11
- Component update: pgBackrest (v1.25 to v1.28)
- Component update: node_exporter (v0.15.1 to v0.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
Notable software features in this release:
- PostgreSQL minor release: v9.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
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
Notable software features in this release:
- PostgreSQL minor release: v9.5.10
- Component upgrade: PG common 184 to 187
- Component upgrade: Backrest v1.20 to v1.25
- Component upgrade: pgaudit_analyze v1.0.6 to v1.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
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
Notable software features in this release:
- Upgrade ODB SDK from v0.14.1 to v0.17.0
- Added service quotas for plans
- Added configurable replica counts
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
Notable software features in this release:
- PostgreSQL v9.5.9
Software fixes in this release:
- Fixed bug where monit triggered PostgreSQL to restart
- Fixed bug where failover did not repair fenced servers
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
Notable software features in this release:
- [Security] Update stemcell to patch Ubuntu Linux kernel security vulnerability (USN-3385-2)
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
Notable software features 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
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 v9.5.8
- PostGIS v2.3.3
- PgAudit v1.0.6
- pgBackrest v1.20
- PLR v8.3.0.17
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
Notable software features in this release:
- Prevent the tile from logging manifests generated by the broker when deploying PostgreSQL, because they contain sensitive information.
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
Notable software features in this release:
- High-availability model
- Auto-failover
- On-demand single-tenant service
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.
This is the GA release, and is not compatible with the previous releases, including the beta release. See detailed release notes below for more information.
v02.090507.101
Release Date: May 23, 2017
Notable software features in this release:
- On-demand single-tenant service
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.
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.
v02.090507.100
Release Date: May 12, 2017
Notable software features in this release:
- On-demand single-tenant service
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.
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.
v1.0.8
Release Date: March 10, 2017
Notable software features 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
Notable software features 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