readme.md

curl -JO https://gist.githubusercontent.com/sebastian13/c313c055a59342acb9f0a7a3d5d03c09/raw/docker-postgres-dump.sh
curl -JO https://gist.githubusercontent.com/sebastian13/c313c055a59342acb9f0a7a3d5d03c09/raw/docker-postgres-restore.sh
chmod +x docker-postgres-(dump|restore).sh

docker-postgres-dump.sh

#!/bin/bash

set -e

# Change to the script's directory & create directory
cd $(dirname "$(readlink -f "$0")")
mkdir -p ./pgdumps

# Start postgres service
docker --log-level=error compose up -d postgres
sleep 5

# Load database name + username
source .env

# Delete old Backups
find ./pgdumps/ -name "*.bak.gz" -atime +7 -exec rm {} \;

# Set the filename
dump="`date +\%Y\%m\%d-\%H\%M`-$POSTGRES_DB.bak.gz"

docker compose exec -T postgres /usr/bin/pg_dump $POSTGRES_DB -U $POSTGRES_USER \
      | gzip --rsyncable > ./pgdumps/$dump

ln -fs $dump ./pgdumps/latest.bak.gz

docker-postgres-restore.sh

#!/bin/bash

# Start postgres service
docker --log-level=error compose up -d postgres
sleep 5

# Load username
source .env

# Find latest dump
latest=$(ls -1t ./pgdumps/*.bak.gz | head -1)

# Restore
gunzip -c $latest | docker compose exec -T postgres /usr/bin/psql -U $POSTGRES_USER $POSTGRES_DB