On Sun, 05 Nov 2006, CSN wrote: > Anybody know of a script that dumps all databases into > corresponding dump files I've written this one in bash: ######################################################### #!/bin/bash pg_dumpall -g > /var/lib/pgsql/backups/globals.sql for dbname in `psql -qXtc " select datname from pg_catalog.pg_database where datname<>'template0' " template1` do pg_dump -b -F t "$dbname" > "/var/lib/pgsql/backups/$dbname.dump" done ######################################################### This would break if any database name has white space. Regards Tometzky -- ...although Eating Honey was a very good thing to do, there was a moment just before you began to eat it which was better than when you were... Winnie the Pooh