Re: [GENERAL] split pg_dumpall backups per database

2008-03-11 Thread Andrej Ricnik-Bay
On 11/03/2008, Luca Ferrari <[EMAIL PROTECTED]> 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. Yo

Re: [GENERAL] split pg_dumpall backups per database

2008-03-11 Thread hubert depesz lubaczewski
On Tue, Mar 11, 2008 at 09:54:47AM +0100, Luca Ferrari 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...

Re: [GENERAL] split pg_dumpall backups per database

2008-03-11 Thread Richard Huxton
Luca Ferrari 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 build a shell script to repeatedly c

[GENERAL] split pg_dumpall backups per database

2008-03-11 Thread Luca Ferrari
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. Thanks, Luca -- Sent via pgsql-general mailing list (pgsql-general@