#!/bin/sh

# ssh://git.mdcc.cx/git/ad1810-stuff.git
# ( view recent version online at http://mdcc.cx/git/wd/ad1810-stuff/scripts/a1-pg_dump )

# dump pg database, preparing it for backup, suitable for possible restore later
# to be run from cron, as user postgres

set -e
umask 027
cd /var/backups/postgresql
for i in $(psql -Atc "SELECT datname FROM pg_catalog.pg_database WHERE datallowconn")
do
  pg_dump --format=custom --file=$i.new --serializable-deferrable $i
  mv $i.new $i.pg
done