Files
bkpscripts/bkppostgres.sh
Ivan Carlos de Almeida e4afa4d4e0
Some checks failed
Build, Push, Publish / Build & Release (push) Failing after 2s
first load
2025-12-16 04:38:42 -03:00

13 lines
761 B
Bash

#!/bin/bash
FILENAMEDATE=$(date +%Y-%m-%dT%H-%M-%S) # date/time formula to compose filename
DOCKERNAME=postgres # docker name to access it and send pg_all command
PGUSER=postroot # username with access to gather all databases using pg_dumpall, usually root
RELATPATH=/backups # relative path folder where the files will be stored
RETDAYS=3 # number of days to retain files before deletion
docker exec -i $DOCKERNAME pg_dumpall -U $PGUSER > .$RELATPATH/$FILENAMEDATE.sql
tar -czf .$RELATPATH/$FILENAMEDATE-DB.tar.gz --remove-files .$RELATPATH/$FILENAMEDATE.sql
find .$RELATPATH -type f -mtime +$RETDAYS -exec rm {} \;
chmod 0600 .$RELATPATH/$FILENAMEDATE-DB.tar.gz