Postgres Backup

If using Postgres in a docker container on unRAID, you can create a user script with the following code to backup your database.

Note, change any parameters as required.

#!/bin/bash

# Define the backup directory (ensure proper quoting)
backup_dir="/mnt/user/backups/postgres"

# Define the database name (ensure proper quoting)
dbName="FileFlows"

# Define the docker container name for the Postgres server (ensure proper quoting)
container="postgresql15"

# Perform the backup
docker exec "$container" pg_dump -U postgres -F t "$dbName" | gzip > "$backup_dir/$dbName-$(date +%Y-%m-%d).tar.gz"

# Check if backup was successful
if [ $? -ne 0 ]; then
    echo "Backup failed!"
    exit 1
fi

# Remove old backup files if there are more than 30
backup_count=$(ls -1Q "$backup_dir" | grep "^$dbName-" | wc -l)
if [ "$backup_count" -gt 30 ]; then
    # Determine the number of files to delete
    files_to_delete=$((backup_count - 30))
    # Delete the oldest files
    ls -1trQ "$backup_dir" | grep "^$dbName-" | head -n "$files_to_delete" | xargs -I {} rm "$backup_dir"/{}
fi