Bash script to backup each schema in a database in a separate backup file.

backup-schemas-separately.sh

#!/bin/bash


if [ $# -eq 0 ]; then
    echo "Usage: ./backup-schemas-separately.sh yourdatabasename" 1>&2
    exit 1;
fi;

db=$1

schemas=$(psql -U postgres -w -h localhost -qAt -c "SELECT nspname FROM pg_catalog.pg_namespace;" "${db}")

for schema in $schemas; do
        pg_dump -F c -w -h localhost -U postgres -n "${schema}" "${db}" > /home/$USER/backups/"${schema}".custom
done