On Tue, 2009-02-10 at 10:15 +0900, Tatsuo Ishii wrote:
> Hi,
>
> 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.
Joshua D. Drake
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 -
http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997