Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WV8Qb-0001oi-7X for pgsql-admin@arkaria.postgresql.org; Tue, 01 Apr 2014 23:49:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WV8Qa-0006i6-Hg for pgsql-admin@arkaria.postgresql.org; Tue, 01 Apr 2014 23:49:12 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WV8QZ-0006hv-DZ for pgsql-admin@postgresql.org; Tue, 01 Apr 2014 23:49:11 +0000 Received: from mailout1.easymail.ca ([64.68.200.113] helo=mailout4.easymail.ca) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WV8QW-0003N7-T1 for pgsql-admin@postgresql.org; Tue, 01 Apr 2014 23:49:10 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout4.easymail.ca (Postfix) with ESMTP id 57710E1F4; Tue, 1 Apr 2014 19:49:03 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at mailout4.easymail.ca Received: from mailout4.easymail.ca ([127.0.0.1]) by localhost (easymail-mailout2.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id OvWQci0gd2cA; Tue, 1 Apr 2014 19:48:58 -0400 (EDT) Received: from [192.168.4.16] (unknown [72.42.64.106]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by mailout4.easymail.ca (Postfix) with ESMTPSA id 7AC3EE197; Tue, 1 Apr 2014 19:48:57 -0400 (EDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 7.2 \(1874\)) Subject: Re: Cascade Standby Configuration in 9.2.4 From: Scott Ribe In-Reply-To: Date: Tue, 1 Apr 2014 17:48:55 -0600 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: <53779B8A-7926-4C62-BABE-A6811B6CBF6D@elevated-dev.com> References: <89222FC3-0F4E-436E-93A5-A68F19F83011@elevated-dev.com> To: Murthy Nunna X-Mailer: Apple Mail (2.1874) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Apr 1, 2014, at 5:20 PM, Murthy Nunna wrote: > Thanks for the clarification Scott... What is the restore_command in reco= very.conf does in case of streaming replication if it doesn't need logs ava= ilable locally on the slave machine. It copies the files. It has no way of knowing whether or not there's a WAL-= shipping replica out there somewhere which needs them. > Do you think if the streaming falls behind, then slave will request maste= r to ship logs?????? The slave does not request the master to ship logs. The slave, when started= uses the WAL files it finds in its locally-available WAL archive, then sta= rts streaming from the master, which requires that there not be a gap betwe= en its local copies and what's still available on the master. This is all covered in the documentation: --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin