#!/bin/bash

#log=/var/log/dbbackup.log

PGUSER=
PGPASSWORD=

export PGUSER
export PGPASSWORD

list=$1
path=$2
age=$3


if [ ! -d "$path" ];
then
 mkdir -p $path
fi

if [ -d "$path" ];
then
 find  $path -maxdepth 1 -type f -ctime +$age  -delete
fi

while read dbname
do
  if [[ "$(awk -F "" '{print $1}' <<< "$dbname")" == "#" ]];
   then
    echo "skiping line"
   else
    echo "$(date +"%h %d %y %H:%M:%S") start dump $dbname" >> $log
    pg_dump  $dbname | gzip  > $path/$dbname-$(date "+%Y-%m-%d").sql.gz
    echo "$(date +"%h %d %y %H:%M:%S") finish dump $dbname" >> $log
    echo "$dbname"
   fi
done < $list

unset PGUSER
unset PGPASSWORD