Magnus Hagander <[EMAIL PROTECTED]> writes: >> "Jeremy Haile" <[EMAIL PROTECTED]> writes: >>> Do you know of any workaround other than restarting the whole server? >>> Can the collector be restarted individually?
> You can use pg_ctl to send the int signal. If it's completely hung, that > may not work. In that case you can kill it from task manager, but that's > equiv of a kill -9, which means that the postmaster will restart all > backends. No, the postmaster does not care how badly the stats collector croaks, because the collector's not connected to shared memory, so there's no risk of collateral damage. It'll just start a new one without bothering the backends. So you can do whatever you have to do to kill the stuck collector --- I was just not sure how to do that under Windows. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/