backup.sh

#!/bin/sh
set -e

CONTAINER="SHARKIE-DB"
DB_USER="sharkie"
DB_NAME="sharkie"
BACKUP_DIR="$HOME/sharkie_backups"
BACKUP_FILE="$BACKUP_DIR/sharkie_$(date +%Y%m%d_%H%M%S).dump"

mkdir -p "$BACKUP_DIR"
docker exec "$CONTAINER" pg_dump -U "$DB_USER" -d "$DB_NAME" --format=custom > "$BACKUP_FILE"
echo "Backup saved to $BACKUP_FILE"

restore.sh

#!/bin/sh
set -e

CONTAINER="SHARKIE-DB"
DB_USER="sharkie"
DB_NAME="sharkie"

BACKUP_DIR="$HOME/sharkie_backups"

if [ -z "$1" ]; then
    echo "Usage: $0 <backup_file.dump>"
    echo "Available backups:"
    ls -1t "$BACKUP_DIR"/*.dump 2>/dev/null || echo "  (none)"
    exit 1
fi

BACKUP_FILE="$1"
if [ ! -f "$BACKUP_FILE" ] && [ -f "$BACKUP_DIR/$BACKUP_FILE" ]; then
    BACKUP_FILE="$BACKUP_DIR/$BACKUP_FILE"
fi

if [ ! -f "$BACKUP_FILE" ]; then
    echo "File not found: $1"
    exit 1
fi

docker exec -i "$CONTAINER" pg_restore -U "$DB_USER" -d "$DB_NAME" --clean --if-exists < "$BACKUP_FILE"
echo "Restored from $BACKUP_FILE"