Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 0CC8B6EF01E for ; Mon, 7 Nov 2011 12:52:16 -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 53189-03 for ; Mon, 7 Nov 2011 16:52:06 +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 B94C76EF012 for ; Mon, 7 Nov 2011 12:52:05 -0400 (AST) Received: from mail8.sea5.speakeasy.net (mail8.sea5.speakeasy.net [69.17.117.53]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id 2F806A70156 for ; Mon, 7 Nov 2011 11:52:03 -0500 (EST) Received: (qmail 27694 invoked from network); 7 Nov 2011 16:52:02 -0000 Received: by simscan 1.4.0 ppid: 12459, pid: 21531, t: 0.2791s scanners: clamav: 0.88.2/m:52/d:13495 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 mail8.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 7 Nov 2011 16:52:02 -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: <4EB80391.1020809@sesda2.com> Date: Mon, 7 Nov 2011 09:52:00 -0700 Cc: Fujii Masao , "[ADMIN]" Content-Transfer-Encoding: quoted-printable Message-Id: References: <4EB80391.1020809@sesda2.com> To: Alex Lai 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/14 X-Sequence-Number: 38608 On Nov 7, 2011, at 9:13 AM, Alex Lai wrote: > Rsync the entire $PGDATA take about an hour to a empty directory. = When I rsync the $PGDATA to the existing directory, it still take 50 = minutes. 1) How slow is your disk? (Rsync computer to computer across the network = should actually be faster if they're not many changes.) 2) Why is an hour to bring the old master up to date such a problem? Are = you planning on failing over that frequently? --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice