"henry" <henry@xxxxxxxxx> writes: > I have tried setting tcp_keepalives_idle = 120 (eg), then restarting PG, > but SHOW ALL; shows tcp_keepalives_idle=0 (ignoring my setting). Just FYI, this is the expected behavior on platforms where the kernel doesn't allow adjustment of the TCP keepalive parameters from userspace. You didn't say what you are running the server on, but the reference to /proc/sys makes me think it's Linux ... which seems odd, because modern Linuxen do allow these things to be adjusted. [ thinks... ] Maybe you were inspecting the value in a Unix-socket connection instead of a TCP connection? This is all irrelevant to your real problem, to judge by the rest of the thread, but I'm curious. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
