pg_dumpall | gzip > pgsql.dmp.gz

for d in `psql -lt | cut -d\| -f1 | grep -v template[01] | grep -v ^$` ;
do
	pg_dump $d > $d.dmp ;
done

psql database_name < pgsql.dmp