Re: split pg_dumpall backups per database

On 11/03/2008, Luca Ferrari <fluca1978(at)infinito(dot)it> wrote:
> Hi all,
> is it possible to instrument pg_dumpall to produce separate sql files for each
> database it is going to backup? I'd like to keep separate backups of my
> databases, but using pg_dump can lead to forgetting a database.....

You could use the method described here for a single database:
http://archives.postgresql.org/pgsql-general/2008-02/msg00343.php

Just slap a wrapper around it (untested), out.sql being the name of
the dump-file:

for i in $(awk '/^CREATE DATABASE/ {print $3}' out.sql); do dump.sh
${i} out.sql ${i}.sql; done

Of course you won't be getting the creation of specific roles or
anything that way.

> Thanks,
> Luca
Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm