pg_dump script

pg_dump.sh

#!/bin/bash -e

DATA=$(date -I)
DEST_DIR=${DEST_DIR}
CURRENT_DIR="${DEST_DIR}/${DATA}"
mkdir -p $CURRENT_DIR
cd $CURRENT_DIR
pg_dumpall -Upostgres -g > global.dmp
for db in $(psql -Upostgres -At -c 'select datname from pg_database where not datistemplate and datallowconn order by datname');do
        echo backup ${db}
        pg_dump -Upostgres -Fc $db > ${db}.dump
done
~