Thread: Daily Vacuums

    #1
  1. Madden Maniac
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2001
    Location
    Finland
    Posts
    519
    Rep Power
    14

    Daily Vacuums


    Hi!

    I'm trying to vacuum my db on daily basis -> cos it's exploding otherwise. I'm just wondering wheter to put this file to my server... So will this do the trick when put into /etc/cron.daily/ folder?

    postgres.cron:

    #!/bin/bash
    DBNAME=db

    #Vacuum
    su - postgres -c "/usr/bin/vacuumdb -f $DBNAME"

    Do I need to edit any other files in order for it to work ???

    Thx for helps,

    Miska

    ###EDIT###
    Ok, It works this way...
    Last edited by Miska; July 10th, 2003 at 03:14 AM.

IMN logo majestic logo threadwatch logo seochat tools logo