[ADMIN] Escaping a blocked sendto() syscall without causing a restart

2013-01-17 Thread Jerry Sievers
Does anyone know if one of the signals below can be sent to break out ,of this state *without* the postmaster sensing a crashed backend? I've seen several times in the past at other companies, backends that will not respond to cancel nor SIGTERM due to syscall that's blocked on IO. Quite often th

Re: [ADMIN] Escaping a blocked sendto() syscall without causing a restart

2013-01-17 Thread Tom Lane
Jerry Sievers writes: > Does anyone know if one of the signals below can be sent to break out > ,of this state *without* the postmaster sensing a crashed backend? > I've seen several times in the past at other companies, backends that > will not respond to cancel nor SIGTERM due to syscall that's