If you are just looking for the least down time between stopping one server and starting the new one you could try Slony see http://gborg.postgresql.org/project/slony1/projdisplay.php Regards, Ben <ogjunk-pgjedan@xxxxxxxxx> wrote in message news:821429.69798.qm@xxxxxxxxxxxxxxxxxxxxxxxxxx > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >
