backup_postgres.sh

#!/bin/bash
MYDATE=$(date +%d-%m-%Y)
for PORT in 5432 5433 5434
do
  echo "Backups on port $PORT"
  export PGPORT=$PORT
  LIST=$(psql -l | awk '{ print $1 }' | grep '^[a-z]' | grep -v template | grep -v postgres)
  for ITEM in $LIST
  do
    NAME=${ITEM}-${MYDATE}.dmp
    echo "Backing up $ITEM to $NAME"
    pg_dump -Fc -f $NAME ${ITEM}
  done
done

# To restore any of the dumps, you can do:
#createdb foo; pg_restore foo.dmp | psql foo