Metacat

#!/bin/bash

#A script to vacuum the db.

#Usage: nohup ./

DB_VERSION=9.3

echo "start to vacuum the db at" >> /tmp/vacuumdb.out

echo `date` >> /tmp/vacuumdb.out

su - postgres  -c "/usr/lib/postgresql/$DB_VERSION/bin/vacuumdb --all >> /tmp/vacuumdb.out 2> /tmp/vacuumdb.err < /dev/null"

echo "end to vacuum the db at " >> /tmp/vacuumdb.out

echo `date` >>  /tmp/vacuumdb.out