dumpem

#!/bin/sh

#for db in commercialads_dev emberrailsapi_dev; do
#  pg_dump -h pg-local -U postgres "$db" > "$db"_dump  
#done

#list=`psql -l | awk '{ print $1}' | grep -vE '^-|^List|^Name|template[0|1]'`
list=`psql -h pg-local -U postgres -l | awk '{ print $1}' | grep -vE '^-|^\||^List|^Name|template[0|1]|postgres|^\('`

for lis in $list; do
  echo dumping $lis ....
  pg_dump -h pg-local -U postgres "$lis" > dumps/"$lis"_dump
  echo '..... dumped\n'
done