crunchy-containers

This release includes the following changes from the previous release (1.7.1):

• fixed a bug in the crunchy-pgadmin4 container that impacted users on RHEL/Openshift platforms, this release only includes this container not the full suite of containers.

This release includes the following changes:

• New Crunchy-PGDump container plus examples and documentation of usage/features
• The Crunchy-PGAdmin4 container now supports TLS and the v2 version of PGAdmin4
• Added sshd capability into postgres and postgres-gis containers to enable better pgbackrest interactions. sshd is disabled by default in all the containers but can be enabled when users need to interact with pgbackrest on a database container
• Removed Crunchy-Watch source files, crunchy-watch has been relocated to a separate repo at https://github.com/crunchydata/crunchy-watch
• Fixed a bug in the postgres and backrest-restore containers whereby permissions would not be set correctly when running on Openshift
• Basic Postgres-GIS examples were created for Docker, Openshift, and Kube
• Added DEBUG flag to all containers to turn off logging of container scripts

This release includes updates to the PostgreSQL packages among other updates including:

• update PostgreSQL 9.5 to version 9.5.10
• update PostgreSQL 9.6 to version 9.6.6
• update PostgreSQL 10 to version 10.1
• update documentation
• updated Helm charts

This release includes the following changes from the previous release:

• Support for PostgreSQL 10.0.
• standardize container names in various examples
• added a recovery timeline parameter to the recovery.conf template, this allows replicas to connect to a failover target (new master), this also allows crunchy-watch to no longer remove old replica pods as part of a failover.
• fixed a crunchy-watch bug, reset FAILURES count after a failover occurs
• implement exporters into crunchy-collect and new Grafana Dashboard template
• rename various references of cluster replication to Postgres community naming conventions, for example, PG_MODE values are now master or replica instead of master or slave
• updated packages for Grafana (4.5.1) and Prometheus (1.7.1)
• added pre and post hooks to crunchy-watch to allow users to run customized scripts
• image tags include the full PostgreSQL version number
• require PG_PRIMARY_PORT in running the PostgreSQL container, as of this release, your examples of running a PostgreSQL container will require you to enter PG_PRIMARY_PORT explicitly
• added deprecation WARNING for usage of older environment variables in PostgreSQL start.sh, if you use the old environment variable names you will see a WARNING in the container log, in a future release the older variable names will cause an error during startup
• PG_PRIMARY_PORT environment variable is now required when creating PostgreSQL container instances, normally this is set to 5432
• updated various examples and scripts to work with both PG9.X and PG10
• includes the latest versions of PostgreSQL including version 10.0 (centos7-10.0-1.6.0), version 9.6.5 (centos7-9.6.5-1.6.0), and version 9.5.9 (centos7-9.5.9-1.6.0)

This is a minor release that includes:

• updated Pgadmin4 Dockerfile to fix a bug when running on Openshift
• updated to PostgreSQL 9.5.9
• updated to PostgreSQL 9.6.5

updates since last release include:

• updated pgbadger packages
• updated documentation and openshift example fixes
• support hostnames with dashes (e.g. resulting in my-db-0) #172
• added TOKEN to kubectl commands in crunchy-watch container script
• bump crunchy-watch image tag to beta version
• update RHEL dockerfiles to meet Redhat certification standards
• update all RHEL dockerfiles to be based off RHEL 7.3
• add PL/R extension to the postgres-gis container
• set auto-update check to false in default configuration for pgadmin4 container
• added --xlogdir support for initdb in the Postgres startup
• added a docker compose example for a primary-replica example
• added OS level metrics to crunchy-collect
• includes new releases of PostgreSQL (9.5.8, 9.6.4)
• converted to using a2x for PDF and HTML and man page generation

changes from the previous release include:

• updated postgres packages to versions 9.6.3 and 9.5.7
• updated documentation
• added signal handler into badger container

Updates to the previous version including:

• add Redhat required Labels to RHEL dockerfiles
• add environment variable to Postgres container to support PG_WAL location to be specified
• fix postgres container to run stanza-create during database initialization to support latest pgbackrest version
• added initial upgrade container, crunchy-upgrade
• cleanup license references
• renamed NFS_PATH to PV_PATH in scripts and documentation to represent this variable's purpose clearer
• added Backrest Restore container, backrest-restore, runs as a Job and will perform a restore using backrest.
• added PostgresFullVersion LABEL to all dockerfiles that contain postgres
• bug fix in PITR example
• documentation updates and corrections

Changes from previous release include:

• added notes on how to run the examples in a minishift installation
• added crunchy-proxy examples and documentation
• added StatefulSet example for Openshift (Origin 1.5)
• removed hard-coded sleep in postgres start.sh script, replaced with pg_isready call
• removed dnsbridge container, no longer needed
• created a check in bin/postgres/start.sh to verify that PG_MASTER_HOST is set when PG_MODE is slave
• updated the postgresql.conf.template to be based on postgres 9.6
• added a postgis version of the setup.sql script
• fixed a pgadmin4 container bug where the internal pgadmin4 database was corrupted
• updated metrics containers including grafana, prometheus, and prometheus push gateway to latest releases
• clean up sample PV and PVC creation and scripts, create CCP_CLI env var to specify either oc or kubectl
• rename BUILDBASE env var to CCPROOT, this way users can more easily spot the CCP related env vars
• renamed files that had nfs in the name to pvc to better indicate the real purpose of the file
• updated the pgadmin4 containers to use the RPM based builds of pgadmin4

This release includes the following changes from the prior release:

• updated docker tests
• cleanup PV, PVC creation and introduce NFS_PATH environment variable
• upgrade postgres packages to latest releases

this release includes the following:

• major refactor of Openshift template examples
• changed backups to use a path of containername-backups, this fixes a major bug that would cause failures in creating replicas to a database that contained backups, with this change, backup files no longer will be placed into the pgdata of a database container persistence path
• split out the GIS packages from crunchy-postgres, now they live in a new container crunchy-postgres-gis, the functionality and user facing interfaces are all the same
• added initial StatefulSet support and example. Starting with Kube 1.5, StatefulSets replace PetSets, using StatefulSets, the Crunchy Postgres container can deploy within a StatefulSet, and use a simple discovery technique to determine which container will become the master in a Postgres cluster configuration.
• added a signal handler to the crunchy-collect server to enable a faster and more clean shutdown of pods that include the collect container
• add WAIT_TIME env var to crunchy-watch to allow the time between labeling and failover configurable
• add 9.6 dockerfile support

This release includes the following changes:

• added pgaudit to crunchy-postgres container, enabled in postgresql.conf, added example
• added a ConfigMap example for OpenShift in which postgresql.conf and pg_hba.conf files are stored/referenced
• updated docker examples for docker version 1.12, use of docker volumes, and documentation
• fix volume permission in grafana and prometheus containers to work with docker volume local driver
• update pgadmin4 container with latest pgadmin4 version
• fix centos postgres container to properly include pgbackrest
• fix crunchy-watch to support SLAVE_TO_TRIGGER_LABEL env var, also cleanup the container start script, examples, and docs.
• fix readiness and liveness probes to work in an OpenShift environment where random UIDs are in effect, the probes are implemented now as bash scripts where they can reference env vars to determine PG_USER

This release includes the following updates:

• fix pgbouncer to run as pgbouncer user instead of root, add nss_wrapper for running in Openshift, also fix the way external configuration files are mounted into the container
• fix pgpool to run as non-root user and add nss_wrapper for running in Openshift
• remove crunchy-dns container build, this container is being refactored and will be added in a later release
• fix postgres and pgbouncer containers to not pull in multiple versions of postgresql packages
• update the metrics example when running in Kube environment
• add initial pgbackrest support
• merged postgres start.sh and start-pg-wrapper.sh startup scripts
• added signal trap in postgres start.sh to perform graceful shutdown of postgres
• updated NFS examples to use supplementalGroup security context setting
• cleaned up postgres start.sh script to do a smarter wait in the case of a replica waiting on its master to be ready
• updated the Kube Helm chart example
• update crunchy-watch to run as postgres user
• add signal handler for cleaner shutdown of pgbouncer, pgadmin4, and pgpool containers

This release includes the following:

• templates for use within Openshift Container Platform allowing for various kinds of deployments from the web console
• updates to various examples to support OSE 3.3
• updated documentation on Openshift Dedicated and Templates
• various bug fixes
• update crunchy-prometheus, crunchy-grafana, crunchy-promgateway to run as daemon user instead of root

Crunchy Data announces Release 1.2.3 of the Crunchy PostgreSQL Container Suite.

Crunchy PostgreSQL Container Suite 1.2.3 includes fixes identified since the previous release and certain updates including the following notable fixes / features:

• update PostgreSQL to 9.5.4
• update pgbadger to 9.0 version
• update pgadmin4 version to latest release candidate beta
• add vacuum job example
• add workshop example to show the use of Openshift templates and new-app command
• update prometheus to 1.1.2 version
• add examples for running in Openshift Dedicated environment
• add pgadmin4 container
• add experimental petset example
• add experimental mesoshere-marathon example
• update grafana to latest version
• update pgpool to latest version
• add rhel7 dockerfiles
• update various documentation files
• add kitchensink example
• add kubehelm example
• update promgateway version
• add CCP_IMAGE_TAG environment variable as an image tagj
• add PITR (point in time recovery) features, examples, documentation
• add CHECKSUMS environment variable to allow initdb to use --data-checksums option
• add vacuum and dba containers

Crunchy PostgreSQL Container Suite is a 100% open source set of pre-packaged Docker containers and Kubernetes services that allows teams to run and manage PostgreSQL in Kubernetes-based environments, such as the Red Hat OpenShift Container Platform. The Container Suite includes a containerized version of PostgreSQL 9.5 with the PostGIS extension, along with PostgreSQL related micro-services packaged in containers.

Crunchy Data is a provider of trusted open source PostgreSQL and enterprise PostgreSQL technology, support and training. For more information, please contact Crunchy Data at [email protected].