Skip to content

Instantly share code, notes, and snippets.

@gaurishhs

gaurishhs/sh

Created February 27, 2024 09:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gaurishhs/1f95c9b6ecaa4d775ed31385c8007d08 to your computer and use it in GitHub Desktop.
Save gaurishhs/1f95c9b6ecaa4d775ed31385c8007d08 to your computer and use it in GitHub Desktop.
Download ZIP
Backup 2 PostgreSQL services zip and upload via rclone deleting older files
Raw
sh
#1/bin/bash
timestamp=$(date +"%H-%M-%S_%d-%m-%Y")
docker exec postgres pg_dump -U gaurish kanboard > ~/dumps/kanboard_dump-$timestamp.sql
docker exec davical-postgres pg_dumpall -U gaurish > ~/dumps/davical_dump-$timestamp.sql
cd dumps
zip -6 -r backup_$timestamp.zip kanboard_dump-$timestamp.sql davical_dump-$timestamp.sql
rclone copy backup_$timestamp.zip crypt:pg
rclone delete crypt:pg --min-age 4d
rm kanboard_dump-$timestamp.sql davical_dump-$timestamp.sql backup_$timestamp.zip
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment