backup.sh 400 B

12345678910111213
  1. #!/bin/bash
  2. source /backups/.env
  3. if [ -z "$POSTGRES_DB" ]; then
  4. echo "Database not specified, defaulting to bookwyrm"
  5. fi
  6. if [ -z "$POSTGRES_USER" ]; then
  7. echo "Database user not specified, defaulting to bookwyrm"
  8. fi
  9. BACKUP_DB=${POSTGRES_DB:-bookwyrm}
  10. BACKUP_USER=${POSTGRES_USER:-bookwyrm}
  11. filename=backup_${BACKUP_DB}_$(date +%F)
  12. pg_dump -U $BACKUP_USER $BACKUP_DB > /backups/$filename.sql