Cascade Standby Configuration in 9.2.4
От | Murthy Nunna |
---|---|
Тема | Cascade Standby Configuration in 9.2.4 |
Дата | |
Msg-id | BD7563973EF8894D905C80593EE9A4ED35C500@MAIL01.fnal.gov обсуждение исходный текст |
Ответы |
Re: Cascade Standby Configuration in 9.2.4
|
Список | 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
В списке pgsql-admin по дате отправления: