Database backup script

#!/bin/bash

DB_NAME="dbName"
DB_USER="dbUSer"
BACKUP_DIR="/home/user/db_backups"
DATE=$(date +'%Y-%m-%d_%H-%M')
BACKUP_FILE="$BACKUP_DIR/$DB_NAME-$DATE.sql.gz"

mkdir -p $BACKUP_DIR

# Dump and compress
PGPASSWORD=password pg_dump -U $DB_USER $DB_NAME | gzip > $BACKUP_FILE

# Delete local backups older than 7 days
find $BACKUP_DIR -type f -mtime +7 -delete