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/