Backup a PostgreSQL database with each schema in a separate folder.

pgdump.sh

#!/bin/bash

export PGDATABASE=${PGDATABASE:-${1:-postgres}} PGUSER=${PGUSER:-${2:-postgres}} PGHOST=${PGHOST:-localhost}

echo '\dn' \
| psql -t \
| awk '/[a-z]/ && /etl/ && !/topology|tiger/ && !/_20/ && $1 != "public" {printf "%s\n",$1}' \
| while read n; do
  echo ${n%%_*}
done \
| sort -u \
| while read n; do
  echo ${n}
  pg_dump -Fc -Fd -C -j2 -O -x -f ${n} -n "${n}*" 2>&1 \
  | tee ${n}.log
done