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 <[EMAIL PROTECTED]> /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 [EMAIL PROTECTED] 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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
