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