"Claudio Lapidus" <clapidus@hotmail.com> writes:
> Tom Lane wrote:
>> pg_dumpall -g >dumpfile
>> for each database:
>> pg_dump -C -s database >>dumpfile
> That was what we ended up doing. It worked very well.
BTW, if you find yourself wanting to do this a lot, it might be worth
your time to instead fix the oversight in pg_dumpall. You'd have to
backpatch this fix:
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/pg_dumpall.c.diff?r1=1.19&r2=1.20
which probably wouldn't be very hard...
regards, tom lane