Re: can't stop autovacuum by HUP'ing the server

On 24-Aug-08, at 10:12 PM, Tom Lane wrote:

> Dave Cramer <pg@fastcrypt.com> writes:
>> I'd like to stop autovac by changing the conf file then sending the
>> server a HUP
>
> Uh ... why should that stop an autovac already in progress?  I'd
> only expect it to affect future launches.
>

Well, I go the extra mile and kill any remaing autovac procs

Here are the logs

2008-08-25 04:00:01 EDT [32276]  LOG:  autovacuum launcher shutting down
2008-08-25 04:00:01 EDT [20526]  LOG:  autovacuum launcher started
2008-08-25 04:00:01 EDT [21404]  FATAL:  terminating autovacuum  
process due to administrator command
2008-08-25 04:00:01 EDT [23418]  FATAL:  terminating autovacuum  
process due to administrator command
2008-08-25 04:00:01 EDT [21703]  FATAL:  terminating autovacuum  
process due to administrator command

So now that I've read this why would the launcher start again ?

Dave
>             regards, tom lane