suchitpuri/crunchy-containers

Docker Containers for Managing PostgreSQL by Crunchy Data

Crunchy PostgreSQL Containers

v1.5, 2024-05-22

Crunchy Container Suite provides Docker containers that enable rapid deployment of PostgreSQL, including administration and monitoring tools. Multiple styles of deploying PostgreSQL clusters are supported.

The containers will execute in the following environments:

• Docker 1.12 and above

• Openshift 3.4 and above

• Kubernetes 1.5 and above

The project includes the following containers:

• crunchy-postgres - executes Postgres

• crunchy-postgres-gis - executes Postgres plus the PostGIS extensions

• crunchy-backup - performs a full database backup

• crunchy-pgpool - executes pgpool

• crunchy-pgbadger - executes pgbadger

• crunchy-watch - performs a form of automated failover

• crunchy-collect - collects Postgres metrics

• crunchy-prometheus -stores Postgres metrics

• crunchy-grafana - graphs Postgres metrics

• crunchy-pgbouncer - pgbouncer connection pooler and simple form of failover

• crunchy-pgadmin4 - pgadmin4 web application

• crunchy-dba - implements a cron scheduler to perform simple DBA tasks

• crunchy-upgrade - allows you to perform a major postgres upgrade using pg_upgrade

• crunchy-backrest-restore - allows you to perform a pgbackrest restore

For Kubernetes users of these containers, there is an associated project worth taking a look at that uses the containers found in this repo and provides a higher level automation. That project is PostgresOperator

Installation

Complete build and install documentation is found here: Install Docs. The provided Dockerfiles build the containers on a Centos 7 base image and use the community PostgreSQL RPMs.

Crunchy provides a commercially supported version of these containers built upon RHEL 7 and the Crunchy supported PostgreSQL. Contact Crunchy for more details at http://www.crunchydata.com.

Examples

Various examples are provided in the Examples documentation for running Docker, Kubernetes, and OpenShift environments.

You will need to set up your environment as per the Install documentation in order to execute the examples.