Re: temporarily stop autovacuum - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: temporarily stop autovacuum
Date
Msg-id 20090210.105027.02302179.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: temporarily stop autovacuum  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
> > Is there any way to stop autovacuum temporarily?(other than edit
> > postgresql.conf and reload it) Pgpool-II does not want autovacuum
> > running while doing "onlie recovery".
> 
> It would be a significant hack but you could update pg_autovacuum to set
> all relations to false.

Thanks. Maybe it will be easier to talk to the autovacuum launcher
daemon process directly? I will look in to the code.
--
Tatsuo Ishii
SRA OSS, Inc. Japan


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: temporarily stop autovacuum
Next
From: KaiGai Kohei
Date:
Subject: Updates of SE-PostgreSQL 8.4devel patches (r1530)