Backup Postgres

backup.sh

#! /bin/sh
DATE=`date +%Y%m%d`
log_file="/home/backup/base_`date '+%Y%m%d'`.log"
sources_dir=/home/backup
file_bk=backup-base_`date '+%Y%m%d'`.sql.gz

cd /usr/local/postgresql/bin/
/usr/bin/pg_dumpall -v -U minha-base | gzip > /home/backup/base-suse_`date '+%Y%m%d'`.sql.gz

cd $sources_dir
retbkp=$?

if [ $retbkp -gt 0 ]
then
  echo "ERRO: Erro nao foi possivel entrar em  $sources_dir  !    .................... data =" `date '+%d-%m-%Y %H:%M:%S'` >> $log_file
  exit 6
else
  echo "INFO: Entrou no diretorio $sources_dir ! .................... data =" `date '+%d-%m-%Y %H:%M:%S'` >> $log_file
fi

# Servidor Aplicacoes
host="172.20.x.x"
user="xxxx"
password="xxx"

ftp -inv <<EOF
  open $host
  user $user $password
  bin
  hash
  put $file_bk
  bye
EOF
retbkp=$?

if [ $retbkp -gt 0 ]
then
  echo "ERRO: Erro nao foi possivel enviar backup para o host $host  !    .................... data =" `date '+%d-%m-%Y %H:%M:%S'` >> $log_file
  exit 6
else
  echo "INFO: Envio backup para o host $host ! .................... data =" `date '+%d-%m-%Y %H:%M:%S'` >> $log_file