Re: postgres do.maintenance question
On Wed, 2004-01-07 at 23:21, Monique Y. Herman wrote:
> How important is it to run the default-install do.maintenance cron job
> if you're running autovacuum? Should I just get rid of it?
>
> Since my last upgrade of postgres on unstable, I've received the
> following email several times a day:
>
> Subject: Cron <postgres@home> /usr/bin/test -x
> /usr/lib/postgresql/bin/do.maintenance &&
> /usr/lib/postgresql/bin/do.maintenance
> -a
>
> Contents:
> The PostgreSQL autovacuum daemon is running and force is not enabled
You can just comment it out in /etc/cron.d/postgresql. The reason it is
left to you to do is that pg_autovacuum is in a different package
(postgresql-contrib) which may not be installed.
>
> To make it a bit weirder, I see the following:
>
> Here's what postmaster.conf says:
>
> # To use autovacuuming, you must have the postgresql-contrib package
> # installed. You must also set AUTOVACUUM to yes in this file.
> #
> # Autovacuuming requires the following options in postgresql.conf:
> # stats_start_collector = true
> # stats_row_level = true
> #
> # If autovacuuming is running, the do.maintenance script, which is run
> # from
> # cron, will not do vacuuming unless it is given the -F (force) option.
> #
> AUTOVACUUM=yes
> #
>
> However, in postgresql.conf, I have
>
> #stats_start_collector = true
> stats_row_level = true
>
> (Only one of the two referenced variables is set.)
stats collection is not related to autovacuuming; that's a separate
issue. The parameters for pg_autovacuum are set in
/etc/postgresql/postmaster.conf
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And not only so, but we glory in tribulations also;
knowing that tribulation worketh patience; And
patience, experience; and experience, hope; And hope
maketh not ashamed; because the love of God is shed
abroad in our hearts by the Holy Ghost which is given
unto us." Romans 5:3-5
Reply to: