create dump foreach db on postgresql

create_postgresql_dumps

#!/bin/bash
echo "Postgresql complete hot backup started"
DIR="/dump-path"

[ ! $DIR ] && mkdir -p $DIR || :
LIST=$(su postgres -c "psql -l" | awk '{ print $1}' | grep -vE '^-|^List|^Name|template[0|1]|^\(|^\||^$')
for d in $LIST
do
  echo "Dump $d started"
  su postgres -c "/usr/bin/pg_dump $d" | gzip -c >  $DIR/$d.dump.gz
  echo "Dump $d finished"
done
echo "Postgresql complete hot backup finished"