On 2011-01-18, Vladislav Geller <vladislav.geller@xxxxxxxxxxx> wrote: > Hello, > > I'm currently in the process of migrating a huge live database from > one part of the world to the other (for local use and data analysis). > The bandwidth does not allow me to get a decent transfer speed. > Furthermore i can not migrate during business hours since the > connection is critical. This leaves me with a timeframe of 9 hours a > day where i can migrate this database. Does anyone have experience he > is willing to share in respect how to migrate such databases? how about using replication? eg: slony1 or wal-shipping compression will help too, but I assume you're already doing that. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
