Re: Stats collector frozen?

Tom Lane wrote:
> Magnus Hagander  writes:
>>> "Jeremy Haile"  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.

Oh, ok.
Then just pick it up in Task Manager or Process Explorer or whatever and
kill it off. Just make sure you pick the right process.

//Magnus