Sean Murphy wrote:
We're talking about 12 GB of data... to do the [probably ill-fated] binary copy in any reasonable amount of time required a portable hard drive and sneaker-net... That's why I'm anxious, probably to the point of stupidity, to avoid a situation where I'll have to bring the db down long enough to pull a backup dump onto portable media, drive to the colo, and restore it...
Slony? Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/