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.....
psql -qAt -c 'select datname from pg_database where datallowconn' | xargs -r -I X pg_dump -C -f X.dump X depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
