Is there a way to detect if the master PostgreSQL (9.3) server becomes unresponsive, and if so, create the trigger file (that is specified in recovery.conf) that initiates the failover process?
Or more specifically, is there some kind of ping or keepalive command that you can use from the slave to see if the master is responding? If so, this can probably be implemented with a shell script rather easily. I have not yet found a command that does something similar to this. Any help is appreciated, thank you.