From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Murthy Nunna <mnunna@fnal.gov>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Cascade Standby Configuration in 9.2.4
Date: Tue, 1 Apr 2014 16:35:16 -0600
Message-ID: <89222FC3-0F4E-436E-93A5-A68F19F83011@elevated-dev.com> (raw)
In-Reply-To: <BD7563973EF8894D905C80593EE9A4ED35C500@MAIL01.fnal.gov>
References: <BD7563973EF8894D905C80593EE9A4ED35C500@MAIL01.fnal.gov>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Sounds like you're confused regarding the difference between WAL-shipping replication and streaming replication. In streaming replication, you don't have 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 <mnunna@fnal.gov> wrote:
> Greetings!
>
> I am setting up cascade standby (primary->slave1->slave2)
>
> Everything is working as expected but I am not sure why it is working though….
>
> Primary: archive = on and archive_command is enabled to send logs to slave1
> I can see in pg_log that logs are being rsynced to slave1
>
> Slave1: archive = on (I am not sure what this does in case of standby) archive_command is enabled to send logs to slave2
> Problem: I don’t see logs going to slave2 though
>
> Slave2:archive and archive_command are commented out
>
> I don’t 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 see the data in slave2. This means somehow logs are getting to slave2 and eventually streaming is catching up….
>
> Can you tell what I am missing here????
>
> Thanks for reading this.
> Murthy
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, mnunna@fnal.gov
Subject: Re: Cascade Standby Configuration in 9.2.4
In-Reply-To: <89222FC3-0F4E-436E-93A5-A68F19F83011@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox