#!/bin/bash
host=xxx.xxx.xxx.xxx
porta=5432
usuario=site
db=site_db
dir=/home/fabio/backup_db/sql/

if [ ! -e "$dir" ]; then
        mkdir -p $dir/{log,sql}
fi

pg_dump -i -h $host -p $porta -U $usuario -F c -b -v -f "${dir}${usuario}`date +%F_%H`hs.backup" $db > "${dir}${usuario}`date +%F_%H`.log" 2>&1
find $dir -mtime +7 -exec rm {} \;
find $dir -mtime +7 -exec rm {} \;