Search Postgresql Archives

Behavior difference for walsender and walreceiver for n/w breakdown case

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have observed that currently incase there is a network break between master and standby, walsender process gets terminated immediately, however
walreceiver detects the breakage after long time.

I could see that there is replication_timeout configuration parameter, walsender checks for replication_timeout and exits after that timeout.

Shouldn't for walreceiver, there be a mechanism so that it can detect n/w failure sooner?


Basic Steps to observe above behavior
1. Both master and standby machine are connected normally,
2. then you use the command: ifconfig ip down; make the network card of master and standby down,
Observation
master can detect connect abnormal, but the standby can't detect connect abnormal and show a connected channel long time.

Note - Earlier I had sent this on Hackers list also, I just wanted to know that is it the behavior as defined by PostgreSQL or is it a bug or a new feature in itself.

          In case it is not clear, I will raise a bug.

          


With Regards,

Amit Kapila

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux