basic postgresql backup

pg_backup.sh

#!/bin/bash

BACKUP_DIRECTORY="/var/lib/_postgresql/backup"
LOGFILE="$BACKUP_DIRECTORY/backup.log"

CURRENT_DATE=$(date "+%Y%m%d")

FILENAME=$BACKUP_DIRECTORY/$1_$CURRENT_DATE.sql


if [ -z "$1" ]
then
    echo "[$(date)] FAILURE: Database name was not specified" >> $LOGFILE
else
    pg_dump -Fc $1  > $FILENAME
    gzip $FILENAME
    echo "[$(date)] SUCCESS: Backup created. File: $FILENAME.gz" >> $LOGFILE
fi

pg_history.sh

#!/bin/bash

BACKUP_DIRECTORY="/var/lib/_postgresql/backup"
LOGFILE="$BACKUP_DIRECTORY/backup.log"

BACKUP_EXTENSION="*.sql.gz"

CURRENT_DATE=$(date "+%Y%m%d")
DAYS=7


for backup in `find $BACKUP_DIRECTORY -mtime +$DAYS -type f -name $BACKUP_EXTENSION`
do
  echo "[$(date)] REMOVING: $backup" >> $LOGFILE
  rm $backup
done