#!/bin/sh for db in `psql -qtc 'SELECT datname from pg_database' | grep -v template`; do pg_dump -Fc $db | gzip -9 > $db.sql.gz; done