In response to "Phoenix Kiula" <phoenix.kiula@xxxxxxxxx>: > Thanks Bill for this recommendation: > > > > *) In the early step dump the data only with pg_dumpall --disable-triggers -a > > > Dumb question. Will this kind of pg_dumpall lead to downtime, I mean > is there a database lock during this time? No. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran@xxxxxxxxxxxxxxxxxxxxxxx Phone: 412-422-3463x4023
