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
datafrom 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
