PostgreSQL 10 Tile Release Notes

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

v05.1018.015

Release Date: August 24, 2021

Notable software features in this release:

  • [Software Component Update] PostgreSQL v10.17-1 updated to v10.18-1
  • [Software Component Update] Support Software Updates

    • PgAudit Set User 2.0.0 -> 2.0.1

Additional notes about this release:

  • This release addresses critical vulnerabilities in PgAudit Set User. This upgrade is strongly recommended. Further information on these CVEs are available here: CVE-2021-38140

v05.1017.014

Release Date: May 27, 2021

Notable software features in this release:
  • [Software Component Update] PostgreSQL v10.16-1 updated to v10.17-1
  • [Software Component Update] Support Software Updates
    • postgres-common 225 -> 226

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-2021-32027 CVE-2021-32028

v05.1016.013

Release Date: March 05, 2021

Notable software features in this release:
  • [Software Component Update] PostgreSQL v10.15-1 updated to v10.16-1
  • [Software Component Update] Support Software Updates
    • postgres-common 222 -> 225
    • PgAudit 1.2.1 -> 1.2.2
    • 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
  • [New Software Feature] Crunchy Backrest logs split into local and s3 folders
  • [New Software Feature] standalone plan Crunchy Backrest configuration file location now matches cluster plans

v05.1015.012

Release Date: December 01, 2020

Notable software features in this release:
  • [Software Component Update] PostgreSQL v10.14-1 updated to v10.15-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:

v05.1014.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.1014.010

Release Date: August 31, 2020

Notable software features in this release:
  • [Software Component Update] PostgreSQL v10.13-1 updated to v10.14-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.1013.009

Release Date: May 29, 2020

Notable software features in this release:
  • [Software Component Update] PostgreSQL v10.12-1 updated to v10.13-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.1012.008

Release Date: Feb 25, 2020

Notable software features in this release:
  • [Software Component Update] PostgreSQL v10.11-1 updated to v10.12-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.1011.007

Release Date: Dec 18, 2019

Notable software features in this release:
  • [Software Component Update] PostgreSQL v10.10-1 updated to v10.11-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.1010.006

Release Date: Aug 13, 2019

Notable software features in this release:
  • [Software Component Update] PostgreSQL v10.09-1 updated to v10.10-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.1009.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 v10.7-1 updated to v10.9-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
    • pgaudit10 1.2.0 to 1.2.1
    • 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
    • pgaudit11 1.3.1
    • postgis25 2.5.0

Additional notes about this release:

  • This release addresses a critical vulnerability in SCRAM verifier parsing. This upgrade is strongly recommended. Further information on this CVE is available here: PostgreSQL Announcement

v05.1007.004

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 v10.6-1 updated to v10.7-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.1006.003

Release Date: December 7, 2018

Notable software features in this release:
  • [Software Component Update] PostgreSQL v10.6-1 to v10.6-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:

v05.1006.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 v10.05 to v10.06
  • [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.1005.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

Additional notes about this release:

  • Crunchy PostgreSQL for PCF can NOT be directly upgraded from v4 with PostgreSQL 9.5 to v5 with PostgreSQL 10.
  • Crunchy PostgreSQL for PCF v5 relies on functionality released in PCF v2.0 – v2.2 to provide support for “on-demand broker” capability.