1. buatlah file dengan ekstensi .sh
2. kemudian isilah source code dibawah ini :
#!/bin/sh
export PGPASSWORD="password_postgre_anda"
BACKUP_DIR="/data/backup_folder_anda/"
if [ $(date +%w) = 6 ]; then
for a in $(date --date='8 days ago' +%Y%m%d) $(date --date='9 days ago' +%Y%m%d) $(date --date='10 days ago' +%Y%m%d) $(date --date='11 days ago' +%Y%m%d) $(date --date='12 days ago' +%Y%m%d) $(date --date='13 days ago' +%Y%m%d)
do
rm $BACKUP_DIR"Database1-"$a".sql" 2> /dev/null
rm $BACKUP_DIR"Database2-"$a".sql" 2> /dev/null
done
fi
/usr/bin/pg_dump NamaDatabase1 -U postgres -h localhost -x -O -f $BACKUP_DIR"Database1-"$(date +%Y%m%d)".sql"
/usr/bin/pg_dump NamaDatabase2 -U postgres -h localhost -x -O -f $BACKUP_DIR"Database2-"$(date +%Y%m%d)".sql"
export PGPASSWORD="password_postgre_anda"
BACKUP_DIR="/data/backup_folder_anda/"
if [ $(date +%w) = 6 ]; then
for a in $(date --date='8 days ago' +%Y%m%d) $(date --date='9 days ago' +%Y%m%d) $(date --date='10 days ago' +%Y%m%d) $(date --date='11 days ago' +%Y%m%d) $(date --date='12 days ago' +%Y%m%d) $(date --date='13 days ago' +%Y%m%d)
do
rm $BACKUP_DIR"Database1-"$a".sql" 2> /dev/null
rm $BACKUP_DIR"Database2-"$a".sql" 2> /dev/null
done
fi
/usr/bin/pg_dump NamaDatabase1 -U postgres -h localhost -x -O -f $BACKUP_DIR"Database1-"$(date +%Y%m%d)".sql"
/usr/bin/pg_dump NamaDatabase2 -U postgres -h localhost -x -O -f $BACKUP_DIR"Database2-"$(date +%Y%m%d)".sql"
EmoticonEmoticon