On Tue, May 24, 2005 at 21:39:15 -0500, John A Meinel <[EMAIL PROTECTED]> wrote: > > By the way, I think doing: > > CREATE DATABASE tempdb WITH TEMPLATE = originaldb; > > Is a much faster way of doing dump and load. I *think* it would recreate > indexes, etc. If it just does a copy it may not show the dump/restore > improvement.
You need to be careful when doing this. See section 18.3 of the 8.0 docs for caveats. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
