David Goodenough writes:
> I would like to do a dump of all the DBs in a postgres system in the manner
> of pg_dumpall, but dumping the DBs out to individual files rather than one
> big one, and using a binary dump to make individual table restores easier.
for d in $(psql -At -c 'select datname from pg_database'); do pg_dump $d >$d.sql; done
--
Peter Eisentraut peter_e(at)gmx(dot)net