Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 6A6491337B49
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 18 Jan 2011 07:32:39 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 19038-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 18 Jan 2011 11:32:32 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtpcorp.com (smtpcorp.com [174.143.60.32])
	by mail.postgresql.org (Postfix) with ESMTP id A850313364DE
	for <pgsql-admin@postgresql.org>; Tue, 18 Jan 2011 07:32:30 -0400 (AST)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
 d=smtpcorp.com;
	s=main; h=References:Message-ID:Date:Subject:From:To;
	bh=mJqROMizqfH1fHNsZZmV1f82gA1Dd4CqLESD1Bw/yB4=;
	b=Og5ehRe1l+xetJIIrjXb8qAcQaElZi2T7F5tG7lbdC8EKKeE6A1wFkfx2KpeESQUn1O2UHYP+Jhr1jXDYt71JQoGXSx0nmgnuLxD/fgVGXEgXGTskxQZ1tev9JbnCMaH;
Received: from ip-118-90-143-30.xdsl.xnet.co.nz ([118.90.143.30] helo=gonzo)
	by smtpcorp.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.70)
	id 1Pf9nb-0004Dm-Il; mid 144
	for pgsql-admin@postgresql.org; Tue, 18 Jan 2011 11:32:31 +0000
Received: from news by gonzo with local (Exim 4.72)
	(envelope-from <news@reversiblemaps.ath.cx>) id 1Pf9nM-0006ZP-QQ
	for pgsql-admin@postgresql.org; Wed, 19 Jan 2011 00:32:16 +1300
To: pgsql-admin@postgresql.org
Path: not-for-mail
From: Jasen Betts <jasen@xnet.co.nz>
Newsgroups: gmane.comp.db.postgresql.admin
Subject: Re: Migrating a live database
Date: 18 Jan 2011 11:32:16 GMT
Organization: Dis (not Dat) Organisation
Lines: 17
Message-ID: <ih3to0$ogv$1@reversiblemaps.ath.cx>
References: <58123383-B024-48E8-B863-651E455A3861@vincorex.ch>
NNTP-Posting-Host: localhost
X-Trace: reversiblemaps.ath.cx 1295350336 25119 127.0.0.1 (18 Jan 2011
	11:32:16 GMT)
X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a
	+M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;
	(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6
	{T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;
	8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
User-Agent: slrn/pre1.0.0-18 (Linux)
X-Smtpcorp-Track: 20799848.1.24841080
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201101/111
X-Sequence-Number: 36551

On 2011-01-18, Vladislav Geller <vladislav.geller@vincorex.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.