On Wed, 2008-02-06 at 17:10 +0100, Zeugswetter Andreas ADI SD wrote: > Simon wrote: > > My proposal is to provide two additional modes: > > --schema-pre-load corresponding to (1) above > > --schema-post-load corresponding to (3) above > > Sounds nice. > For a large schema we might rather want one switch that dumps 2 files, > no ? > Probably also better from a mvcc perspective. >
Assuming pg_dump/pg_reload supports pre/data/post phases, as Simon suggests, the multi-file options could also be handled by -Fc and using pg_restore, correct? Or would the multi-file options provide any new functionality? Regards, Jeff Davis ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend