We are in process of testing a Postgres 9.6 active-passive HA cluster using streaming replication on Rhel 7.5.
We are seeing below issue with the setup :
1. When a failover is triggered while data is being added to the primary by killing primary (killall -9 postgres), the failed node is restarted to but doesn't start streaming. It starts in disconnect mode. We checked and notice that the wal receiver process is not started. Need help in
1. To check why the wal receiver process is not stated ? Is killed -9 leaving some processes uncleaned because of which the walk receiver is notstarting ?
2. How can we simulate abrupt shut down of postgresql ? We want to simulate case where primary goes down abruptly
