#! /bin/bash
TIMESTAMP=$(date +"%F")
ANO=$(date +%Y)
MES=$(date +%m)
DIA=$(date +%d)
BACKUP_DIR="/backup/$TIMESTAMP"
echo "RRRRRRRRRRRRRRRRRRRRRRRRRR"
mkdir -p "$BACKUP_DIR/"
echo "$BACKUP_DIR/"
databases=`psql --user=postgres -l -t | cut -d'|' -f1 | sed -e 's/ //g' -e '/^$/d'`
echo "databeses"
echo "$databases"
for db in $databases; do
echo "$db"
if [ "$db" != "template0" ] && [ "$db" != "template1" ] && [ "$db" != "dbraulsoares2" ] ; then
echo Dumping $db to $BACKUP_DIR
pg_dump --user=postgres -Fc $db > $BACKUP_DIR/$db.backup
aws s3 cp $BACKUP_DIR/$db.backup s3://esusversa/ESUS/$ANO/$MES/$DIA/
fi
echo "$db"
echo "DDDDDDDDDDDDDD"
find /backup/2023-* -mtime +1 -exec rm -Rf {} \;
done
#rm -rf $BACKUP_DIR