30 lines
602 B
Bash
30 lines
602 B
Bash
#!/bin/sh
|
|
|
|
# Backup for databases Postgresql
|
|
# Crontab will execute everyday 2:10 a.m.
|
|
|
|
# Add next line to crontab /etc/crontab
|
|
# 10 2 * * * psk $HOME/.scripts/backup_db.sh
|
|
|
|
backup_dir=$HOME/.backups
|
|
|
|
DBLIST="
|
|
DEMO
|
|
"
|
|
|
|
today="$(date +%Y-%m-%d)"
|
|
yesterday="$(date +%Y-%m-%d -d 'yesterday')"
|
|
|
|
|
|
for DB in ${DBLIST}
|
|
do
|
|
filename=${DB}-${today}.dump
|
|
/usr/bin/pg_dump --format=c --no-owner -f $backup_dir/$filename $DB
|
|
yesterday_file=$backup_dir/${DB}-${yesterday}.dump
|
|
if [ -e $yesterday_file ]
|
|
then
|
|
echo "Removing old file... " ${yesterday_file}
|
|
#rm ${yesterday_file}
|
|
fi
|
|
done
|