Re: Dump all databases to corresponding files

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