jianhen-voc/deploy/backup.sh

#!/usr/bin/env bash
set -euo pipefail

BACKUP_DIR=/var/backups/jianhen-voc
CONFIG=/etc/jianhen-voc/config.json
STAMP="$(date +%Y%m%d-%H%M%S)"

install -d -o voc -g voc -m 0750 "$BACKUP_DIR"
DATABASE_URI="$(node -e "const c=require('$CONFIG');process.stdout.write(c.parse.databaseURI)")"
pg_dump --format=custom --no-owner --no-acl --dbname="$DATABASE_URI" \
  --file="$BACKUP_DIR/jianhen-voc-$STAMP.dump"
find "$BACKUP_DIR" -type f -name 'jianhen-voc-*.dump' -mtime +14 -delete