2.3.2

This release provides the following updates:

• PostgreSQL minor version updates
• pgBackrest version updated from 2.10 to 2.13

2.3.1

This release is a bug fix release, the following is included:

crunchy-vacuum has been deprecated
#993 - Docker pgadmin4 example fails: Could not create pgAdmin4 database
#927 - provide configurable url for root for pgadmin
#973 - run.sh does not error if storage not created
#771 - add backoff limits to example jobs
pgBackrest updated to 2.10
Updated prometheus and grafana versions
Add environment variable to not deploy default grafana dashboards
Documentation updates

2.3.0

This release includes:

• Crunchy Watch has been deprecated, please see the Crunchy Operator for fail over support.
• Updated to the least privaleges that Scheduler needs to run with.
• Fixed harded coded Postgres port in the postgres template.
• Updated pgbackrest to use environment variables.
• Updated multpile examples take not of pgbackrest in particular.
• Added labels to to be used or cleaning up examples.
• #925 Limit listener of temporary pg to unix domain socket - thanks to @gkranis for this fix.
• added sshd back into postgres containers to support pgbackrest integration in the Operator
• added a way to disable node exporter metrics from being collected

2.2.0

Support for PostgreSQL 11.1.
Crunchy DBA container has been deprecated and was replaced with the Crunchy Scheduler Container
#891 Added filesystem metrics missing for PostgreSQL volumes
#847 remove sshd from pg containers
#885 Updated documentation for OCP RBAC setup for running the examples
#855 log_statement configurable for PG containers
#770 Error code displayed when a pg_basebackup that fails.
#745 Fix bashrc and bash_profile
#718 Removed the need of nss_wrapper in the containers
#701 Badger Custom Opts
#688 Update examples to use separate subdirectories
Add permissions to service account - thanks to gadelkareem for submitting the fix
Updated documentation to use Openshift Container Platform 3.11
Added updates and test to the automated test harness.
Added ability to use GIS container with backrest examples.
Other documentation updates and corrections.

2.1.0

Release 2.1.0 provides updates to the latest versions of PostgreSQL. In addition pgmonitor and documentation has been updated.

The following changes, additions, and updates are included:

• PostgreSQL packages updated to 10.5, 9.6.10, 9.5.14
• PGPool packages updated to 3.5.16 (9.5 container) and 3.7.5 (9.6/10 container)
• Data Checksums have been enabled on the images.
• pgmonitor integration has been upgraded
• pg_upgrade example was updated
• Minor formatting changes have been applied to files.
• Minor updates to have been applied to examples
• Documentation has been updated

Release 2.0.0

This release is a major release and includes the following:

• improved testing
• #589 - removed the deprecation warning for users using the older environment variable names in the Postgres container
• #627 - added pre and post hooks into the Postgres container to allow users a means to provide custom script execution as part of the PG container lifecycle
• #548 - fix to pgdump container
• #643 - included a test suite for the Kube and OCP examples
• revised documentation based on Hugo
• #644 - fixed missing volume spec in pgrestore example
• #611 - updated OCP template examples to use storage classes
• #594 - fixed PITR example
• #412 - updated the pgbouncer container and examples to use latest features and be more streamlined
• #661 - added pre and post hooks into the Postgres containers allowing users access to the database lifecycle
• #662, #631 - update pgadmin4 images to latest which fixes a bug in resetting passwords
• updated pgbadger to support incremental report logic
• updated pgbackrest version
• #628 - refactor pgbouncer container adding more features
• better support for GKE/GCP added into to examples and documentation

Release 1.8.3

Release 1.8.3 had the primary goals of improving consistency, readability, and ease of use across the Container Suite; this applies from both a developer and end-user point of view.

The following changes, additions, and updates are included:

• Added an API healthcheck event loop before registering the Grafana dashboard and data source. (Bug Fix)
• Renamed the crunchy-dump container to crunchy-pgdump.
• Renamed the crunchy-restore container to crunchy-pgrestore.
• Refactored OpenShift templates; added new examples, brought templates up-to-date, and consolidated all templates into a single directory.
• DockerHub documentation for all containers has been updated with detailed descriptions. These can be viewed here: https://hub.docker.com/u/crunchydata/
• Kubernetes and OpenShift examples have been merged into a single directory ($CCPROOT/examples/kube). The examples can be run on either environment seamlessly with the use of the $CCP_CLI environment variable.
• Brought all Docker examples in line with the updated Kubernetes and OpenShift examples.
• All examples now create components that imitate the folder name and their function. For instance, if you have a folder named “example”, it will create a pod and service named “example”, a PVC hosting /pgdata called “example-pgdata”, and so on.
• Increased the use of flexible environment variables already in-use across all example scripts, to improve the ability to change a variable once rather than updating multiple hard-coded variables.
• All cleanup scripts for all examples now correctly clean up all created components.
• Altered line in the pg_hba.conf file that is built by default with the crunchy-postgres container for security purposes; changed it from host all all 127.0.0.1/32 trust to host all all 127.0.0.1/32 md5.
• All examples now create PV and PVC’s depending on the environment you are running (NFS, Dynamic, or HostPath). Additional environment variables will be required to be defined in the .bashrc file, detailed here: https://github.com/crunchydata/crunchy-containers/blob/master/docs/install.adoc#configure-container-storage
• All created PV’s now make use of the CCP_STORAGE_CAPACITY and CCP_STORAGE_MODE variables to define the storage size and mode required to be used. This is replacing the current hard-coded variables in place and will require these variables to be set in the .bashrc file.
• As a result of the storage refactoring, the statefulset-dyn example is no longer necessary and has been deprecated.
• All Red Hat Atomic documents are now consolidated into a subdirectory under the main docs/ folder for better organization.
• All logs for the containers have been updated for improved accuracy, consistency, and readability, including new color-coded log information.
• The method by which the $PGROOT environment variable is set has been refactored and is consistently created across different containers.
• Pull request and issue templates have been created to make the process of submitting a PR or issue more consistent and informational.
• An editor configuration file has been added to ensure consistency across different coding platforms.
• Hardcoded backup paths for the pgrestore and restore examples have now been replaced by dynamically grabbing the last backup path from the running backup job.
• #551 - refactored pgrestore and pgdump to take basic defaults
• fixes PITR example and logic

Release 1.8.2

this release includes the following features:

• updated examples to use unique PVCs instead of sharing a common PVC
• updated prometheus and grafana containers to latest versions
• fixed statefulset logic in postgres container, new PG_REPLICA_HOST environment variable added to support statefulset logic, updated statefulset examples
• update the PITR examples
• #368 - updated the exporters within crunchy-collect
• #366 - updated the metrics containers images, removed the need for crunchy-promgateway, updated docs
• updated the pgpool container to work better with Secrets that hold the pgpool configuration, updated the pgpool examples to be more production realistic using a Secret to hold the pgpool config files and also use a Deployment for running the container
• #476 - modified pgadmin4 container for improved security
• modified the examples to use CCP_STORAGE_PATH instead of PV_PATH, also changed to CCP_NFS_IP instead of the previous LOCAL_IP environment variable setting, this impacts previous examples that use the older names.

Release 1.8.1

This is a minor release that includes the following changes from 1.8.0:

• updated PostgreSQL packages (10.3, 9.6.8, 9.5.12)
• new pgaudit examples

Release 1.8.0

This release includes the following changes:

• a new crunchy-restore container that performs a restore from a pgdump or pgdumpall
• fixed issues in 1.7.1 related to OCP permissions that broke the pgbackrest restore capability and sshd capability
• removed openssh-client from all containers
• updated to the latest Postgres releases
• postgres-gis is broken using PG 9.5 due to the PGDG packages not working with PostGIS. This impacts the centos container image.
• added TLS 1.2 requirement to pgadmin4 when running in https mode