Fastest DB restore options

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