In response to "Phoenix Kiula" <[EMAIL PROTECTED]>: > 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/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general