postgres db for IBSng

backup to ftp

#!/bin/bash
su postgres -c "pg_dump IBSng" > IBSng_"`date +%Y-%m-%d`".sql
#tar czf IBSng_"`date +%Y-%m-%d`".tar.gz  IBSng_"`date+%Y-%m-%d`".sql
DELDATE=$(date -d "-31 days" +"%Y-%m-%d")
HOST=aaaa
USER=ssss
PASS=zzzzz
ftp -inv $HOST << EOF
user $USER $PASS
cd ibsng-backups
put IBSng_"`date +%Y-%m-%d`".sql
mdel IBSng_$DELDATE.sql
bye
EOF
DELDATE2=`date -d "-7 days" +"%Y-%m-%d"`
rm IBSng_$DELDATE2.sql
#rm IBSng_"`date +%Y-%m-%d`".tar.gz