Cascade Standby Configuration in 9.2.4

From: Murthy Nunna <mnunna(at)fnal(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Cascade Standby Configuration in 9.2.4
Date: 2014-04-01 22:17:06
Message-ID: BD7563973EF8894D905C80593EE9A4ED35C500@MAIL01.fnal.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2014-04-01 22:35:16 Re: Cascade Standby Configuration in 9.2.4
Previous Message Venkata Balaji Nagothi 2014-04-01 00:49:50 Re: PostgreSQL 9.3 logging: separate log messages