| From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Migrating a live database |
| Date: | 2011-01-18 11:32:16 |
| Message-ID: | ih3to0$ogv$1@reversiblemaps.ath.cx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 2011-01-18, 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?
how about using replication?
eg: slony1 or wal-shipping
compression will help too, but I assume you're already doing that.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | French, Martin | 2011-01-18 13:46:37 | Re: Postgres Backup Utility |
| Previous Message | Vladimir Rusinov | 2011-01-18 08:10:17 | Re: Migrating a live database |