On 11/03/2008, Luca Ferrari <fluca1978@infinito.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