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
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 |