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

On 25-Aug-08, at 10:43 AM, Alvaro Herrera wrote:

> Dave Cramer wrote:
>
>> 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
>
> What did you SIGHUP, the launcher or postmaster?  You need the latter.
> The launcher should exit automatically at that time.

No, I am HUP'ing the postmaster then subsequently killing any  
autovacuums still around, which may be the problem.

I may be killing the launcher prematurely. I'll try again tonight.

Dave
>
>
> -- 
> Alvaro Herrera                                http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support