Postgres Pro
Downloads
Home   >   mailing lists

Re: can't stop autovacuum by HUP'ing the server - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: can't stop autovacuum by HUP'ing the server
Date
Msg-id 16E81A65-0526-4685-BABE-7308EEE676CC@fastcrypt.com
Whole thread Raw
In response to Re: can't stop autovacuum by HUP'ing the server  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: can't stop autovacuum by HUP'ing the server  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: IN, BETWEEN, spec compliance, and odd operator names
Next
From: Dave Cramer
Date:
Subject: Re: can't stop autovacuum by HUP'ing the server