Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 227B0700F00 for ; Mon, 7 Nov 2011 13:26:19 -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 64233-03-6 for ; Mon, 7 Nov 2011 17:25:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from asbnvacz-mailrelay01.megapath.net (asbnvacz-mailrelay01.megapath.net [207.145.128.243]) by mail.postgresql.org (Postfix) with ESMTP id 949D515AD647 for ; Mon, 7 Nov 2011 13:21:52 -0400 (AST) Received: from mail3.sea5.speakeasy.net (mail3.sea5.speakeasy.net [69.17.117.42]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id 0F682A70101 for ; Mon, 7 Nov 2011 12:21:50 -0500 (EST) Received: (qmail 10948 invoked from network); 7 Nov 2011 17:21:50 -0000 Received: by simscan 1.4.0 ppid: 15512, pid: 6253, t: 1.2630s scanners: clamav: 0.88.2/m:52/d:10739 spam: 3.0.4 Received: from 25-76-42-72.skybeam.com (HELO [192.168.2.16]) (sribe@elevated-dev.com@[72.42.76.25]) (envelope-sender ) by mail3.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 7 Nov 2011 17:21:48 -0000 Subject: Re: streaming replication Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: <4EB7BC8B0200002500042AFF@gw.wicourts.gov> Date: Mon, 7 Nov 2011 10:19:42 -0700 Cc: "[ADMIN]" Content-Transfer-Encoding: quoted-printable Message-Id: <8CC5F53E-1D02-43DE-8198-D2BB9297173E@elevated-dev.com> References: <4EB80391.1020809@sesda2.com> <4EB7BC8B0200002500042AFF@gw.wicourts.gov> To: "Kevin Grittner" X-Mailer: Apple Mail (2.1084) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.18 tagged_above=-10 required=5 tests=BAYES_00=-1.9, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 201111/17 X-Sequence-Number: 38611 On Nov 7, 2011, at 10:10 AM, Kevin Grittner wrote: > If the bottleneck is the network, be sure that you are using a > daemon on the remote side; otherwise you do drag all the data over > the wire for any file which doesn't have an identical timestamp and > size. An example of how to do that from the rsync man page: >=20 > rsync -av -e "ssh -l ssh-user" rsync-user@host::module /dest >=20 > This will try to identify matching portions of files and avoid > sending them over the wire. ??? The normal way of using will using rolling checksums rather than = sending all the data over the network: rsync -av rsync-user@host:/source /dest --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice