On Tue, Jan 18, 2011 at 8:07 AM, Vladislav Geller <
> 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).
In response to
pgsql-admin by date
|Next:||From: Vladimir Rusinov||Date: 2011-01-18 07:46:53|
|Subject: Re: How do I stop/disable PITR and safely clean WAL segments?|
|Previous:||From: Scott Marlowe||Date: 2011-01-18 06:30:39|
|Subject: Re: Migrating a live database|