PG backup all databases

dump_all.sh

#!/bin/bash

BACKUP_DIR=${HOME}'/pgbackup/'
DATE=`date +'%Y-%m-%d_%H-%M'`

for d in `psql postgres -c 'select datname from pg_database' -t`;
do
        BACKUP_FILE=${BACKUP_DIR}${d}_${DATE}.dump

        pg_dump -f ${BACKUP_FILE} --format=d -j 4 -v -x -O  --compress=7 ${d}
        tar -zcvf ${BACKUP_FILE}.tar ${BACKUP_FILE}

        rm -rf ${BACKUP_FILE}
done;

exit 0;