Fastest DB restore options

[ogjunk-pgjedan(at)yahoo(dot)com]

Hello,

I have a fairly large DB to dump and restore as fast as possible.  I'm moving from 8.0.3 to 8.2.3! :)

I normally dump with these options:

  -d MyDB --clean --inserts --column-inserts --format=P

But the last time I tried that, the restore took foreeeeeeeeeeeeeever.  So I'm looking for the fastest way to import data from the old DB to the new one.  Judging from pg_dump man page the following should be the fastest dump & restore:

  -d MyDB --format=c --ignore-version
 
Is there anything else I can do to make the restore as fast as possible?

Thanks,
Otis

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Simpy -- http://www.simpy.com/  -  Tag  -  Search  -  Share