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