From: | Vladimir Rusinov <vladimir(at)greenmice(dot)info> |
---|---|
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 07:39:32 |
Message-ID: | AANLkTimg8dQFvSRZ1GRw998YfzDBQ0uJ8OWns-5jSH2R@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, Jan 18, 2011 at 8:07 AM, 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?
>
run pg_start_backup() and use rsync on live data files to transfer them.
If sync won't finish in 9 hours, abort it, run pg_stop_backup() and continue
next day - I assume most of the data won't change, so rsync won't
re-transfer it (but will calculate hash and compare).
--
Vladimir Rusinov
http://greenmice.info/
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Rusinov | 2011-01-18 07:46:53 | Re: How do I stop/disable PITR and safely clean WAL segments? |
Previous Message | Scott Marlowe | 2011-01-18 06:30:39 | Re: Migrating a live database |