Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WV7HK-0007fs-L9 for pgsql-admin@arkaria.postgresql.org; Tue, 01 Apr 2014 22:35:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WV7HK-0002uH-5U for pgsql-admin@arkaria.postgresql.org; Tue, 01 Apr 2014 22:35:34 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WV7HJ-0002uA-Da for pgsql-admin@postgresql.org; Tue, 01 Apr 2014 22:35:33 +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 1WV7HF-00024C-RW for pgsql-admin@postgresql.org; Tue, 01 Apr 2014 22:35:32 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout4.easymail.ca (Postfix) with ESMTP id 13D49E22F; Tue, 1 Apr 2014 18:35:25 -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 8u8lP6qwl--F; Tue, 1 Apr 2014 18:35:19 -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 05D53E20C; Tue, 1 Apr 2014 18:35:18 -0400 (EDT) Content-Type: text/plain; charset=windows-1252 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 16:35:16 -0600 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: <89222FC3-0F4E-436E-93A5-A68F19F83011@elevated-dev.com> References: To: Murthy Nunna X-Mailer: Apple Mail (2.1874) X-Pg-Spam-Score: -0.0 (/) 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 Sounds like you're confused regarding the difference between WAL-shipping r= eplication and streaming replication. In streaming replication, you don't h= ave to ship WAL files. (You need to be sure that the WALs are preserved on = master long enough for the slave to stream them, but you don't have to ship= them.) On Apr 1, 2014, at 4:17 PM, Murthy Nunna wrote: > Greetings! >=20=20 > I am setting up cascade standby (primary->slave1->slave2) >=20=20 > Everything is working as expected but I am not sure why it is working tho= ugh=85. >=20=20 > Primary: archive =3D on and archive_command is enabled to send logs to sl= ave1 > I can see in pg_log that logs are being rsynced to slave1 >=20=20 > Slave1: archive =3D on (I am not sure what this does in case of standby) = archive_command is enabled to send logs to slave2 > Problem: I don=92t see logs going to slave2 though >=20=20 > Slave2:archive and archive_command are commented out >=20=20 > I don=92t see anywhere logs being shipped from slave1 to slave2 but when = I stop slave2 and do some activity on primary and later restart slave2 I se= e the data in slave2. This means somehow logs are getting to slave2 and eve= ntually streaming is catching up=85. >=20=20 > Can you tell what I am missing here???? >=20=20 > Thanks for reading this. > Murthy --=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