
July 2nd, 2003, 06:53 AM
|
 |
Madden Maniac
|
|
Join Date: Jun 2001
Location: Finland
Posts: 519
 
Time spent in forums: 1 Day 3 h 47 m 50 sec
Reputation Power: 12
|
|
|
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.
|