Re: Dump all databases to corresponding files

# tometzky(at)batory(dot)org(dot)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