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

On Tue, Aug 26, 2008 at 9:59 AM, Dave Cramer <pg@fastcrypt.com> wrote:

On Tue, Aug 26, 2008 at 9:37 AM, Alvaro Herrera <alvherre@commandprompt.com> wrote:

Dave Cramer wrote:

> Ok, here are the logs from last night
>
> 2008-08-26 04:00:02 EDT [25407]  LOG:  received SIGHUP, reloading
> configuration files
> 2008-08-26 04:00:02 EDT [22649]  LOG:  autovacuum launcher shutting down
> 2008-08-26 04:00:02 EDT [30438]  LOG:  autovacuum launcher started
>
>
> you can see the SIGHUP, the launcher being shut down, and starting right
> back up again ???
>
> is this expected behaviour ?

Certainly not, and that's not what I see here either.  I assume process
25407 is (was) the postmaster, yes?

If you "show autovacuum", is it on?

Yes that was the postmaster, and I did check to see if autovacuum was on, and it was not.

Dave

So where do we go from here ?