Something went wrong. Try again.
Docker images for postgres extended with management bash scripts.
Something went wrong. Try again.
1.0 kB · 38 lines
at main
123456789101112131415161718192021222324252627282930313233343536373839#!/usr/bin/env bash### Create a database backup.###### Usage:### $ docker-compose -f <environment>.yml (exec |run --rm) postgres backupset -o errexitset -o pipefailset -o nounsetworking_dir="$(dirname ${0})"source "${working_dir}/_sourced/constants.sh"source "${working_dir}/_sourced/messages.sh"message_welcome "Backing up the '${POSTGRES_DB}' database..."if [[ "${POSTGRES_USER}" == "postgres" ]]; then message_error "Backing up as 'postgres' user is not supported. Assign 'POSTGRES_USER' env with another one and try again." exit 1fiexport PGHOST="${POSTGRES_HOST}"export PGPORT="${POSTGRES_PORT}"export PGUSER="${POSTGRES_USER}"export PGPASSWORD="${POSTGRES_PASSWORD}"export PGDATABASE="${POSTGRES_DB}"backup_filename="${BACKUP_FILE_PREFIX}_$(date +'%Y_%m_%dT%H_%M_%S').sql.gz"pg_dump | gzip > "${BACKUP_DIR_PATH}/${backup_filename}"message_success "'${POSTGRES_DB}' database backup '${backup_filename}' has been created and placed in '${BACKUP_DIR_PATH}'."