| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Vladislav Geller <vladislav(dot)geller(at)vincorex(dot)ch> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Migrating a live database |
| Date: | 2011-01-18 06:30:39 |
| Message-ID: | AANLkTikh=i8mOGDkiJOypQRKAOqeJTANryOCOv+_ot2X@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Jan 17, 2011 at 10:07 PM, Vladislav Geller
<vladislav(dot)geller(at)vincorex(dot)ch> 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?
Do you have the bandwidth to transfer the whole database in those 9 hours?
Or, can you set up replication using slony / PITR / Bucardo /
Londiste, and use traffic shaping to make sure it doesn't flood your
network and wait a week or two til it catches up?
Those are the only two answers I can think of.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Rusinov | 2011-01-18 07:39:32 | Re: Migrating a live database |
| Previous Message | Gnanakumar | 2011-01-18 05:18:13 | How do I stop/disable PITR and safely clean WAL segments? |