Re: Dump all databases to corresponding files

# tometzky@batory.org.pl / 2006-11-06 12:26:43 +0100:
> 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.

    Why don't you use "while" then?

    psql -qXtc "$query" template1 | while read dbname; do
        pg_dump -b -F t "$dbname" > "/var/lib/pgsql/backups/$dbname.dump"
    done

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991