backup_pg_dump.sh

#!/bin/bash
# backup Location

dir="/home/dell/"

# Name of the backup files
date=`date +%d-%m-%Y`

databases=`psql -l -t | cut -d'|' -f1 | sed -e 's/ //g' -e '/^$/d'`

for i in $databases; do  if [ "$i" != "postgres" ] && [ "$i" != "template0" ] && [ "$i" != "template1" ] && [ "$i" != "template_postgis" ]; then    
    echo Backup $i to $dir$i\_$date.sql    
    pg_dump $i > $dir$i\_$date.sql
  fi
done

# given the permission
# chmod +x backup_pg_dump.sh
# run : ./backup_pg_dump.sh