Makefile

## dcape-app-pg-backup Makefile:
## Backup pg databases via docker container with crond
#:
SHELL      = /bin/sh
CFG       ?= .env

#- Enable work
BACKUP_ENABLED  ?= no
#- DB names
DB_NAME         ?= template1
#- Cron rules
BACKUP_CRON     ?= 10 5 * * *
#- cron period (15min|daily|hourly|monthly|weekly)
BACKUP_PERIOD   ?= daily
#- project name
APP_TAG         ?= pg-backup
#- app root
APP_ROOT        ?= $(PWD)
#- db container
DB_CONTAINER    ?= #

PERSIST_FILES    = Makefile pgbackup.sh

USE_DCAPE_DC    := no

# ------------------------------------------------------------------------------
# Create script
# DCAPE_DB_DUMP_DEST must be set in pg container

define EXP_SCRIPT
[ "$$DCAPE_DB_DUMP_DEST" ] || { echo "DCAPE_DB_DUMP_DEST not set. Exiting" ; exit 1 ; } ; \
DBS=$$@ ; \
[[ "$$DBS" ]] || DBS=all ; \
dt=$$(date +%y%m%d) ; \
if [[ $$DBS == "all" ]] ; then \
  echo "Exporting all databases..." ; \
  DBS=$$(psql --tuples-only -P format=unaligned -U postgres \
    -c "SELECT datname FROM pg_database WHERE NOT datistemplate AND datname <> 'postgres'") ; \
fi ; \
echo "Backup DBs: $$DBS" ; \
for d in $$DBS ; do \
  dest=$$DCAPE_DB_DUMP_DEST/$${d%%.*}-$${dt}.tgz ; \
  echo -n $${dest}... ; \
  [ -f $$dest ] && { echo Skip ; continue ; } ; \
  pg_dump -d $$d -U postgres -Ft | gzip > $$dest || echo "error" ; \
  echo Done ; \
done
endef
export EXP_SCRIPT

# ------------------------------------------------------------------------------

-include $(CFG)
export

# ------------------------------------------------------------------------------
# Find and include DCAPE_ROOT/Makefile
#- dcape compose docker image
DCAPE_COMPOSE   ?= dcape-compose
DCAPE_ROOT      ?= $(shell docker inspect -f "{{.Config.Labels.dcape_root}}" $(DCAPE_COMPOSE))

ifeq ($(shell test -e $(DCAPE_ROOT)/Makefile.app && echo -n yes),yes)
  include $(DCAPE_ROOT)/Makefile.app
else
  include /opt/dcape/Makefile.app
endif

# ------------------------------------------------------------------------------
## DB operations
#:
.PHONY: backup

## dump all databases or named database
backup: docker-wait
	@echo "*** $@ ***"
	@if [ "$$BACKUP_ENABLED" = "yes" ] ; then echo "$$EXP_SCRIPT" | docker exec -i $$DB_CONTAINER bash -s - $$DB_NAME ; else echo Disabled ; fi

# -----------------------------------------------------------------------------

# echo "$$BACKUP_CRON    make backup" > /etc/crontabs/root