Investigate crashing postgres on cbs-hub
The postgresql process on cbs-hub has been crashing for the last few days.
It's being killed by the kernel OOM killer. Symptoms seem to be hundreds of open psql processes, which eventually consume all system RAM and then get killed off, at which point Zabbix alerts and I go restart it.
I've been watching the logs for a while to see if I can catch it, but I'm not seeing much. Probably need to up the logging or run some postgresql queries.
We could add some more postgres Zabbix logging too.
issue