Project

General

Profile

1 8922 tao
#!/bin/bash
2
#A script to vacuum the db.
3
#Usage: nohup ./
4
DB_VERSION=9.3
5
echo "start to vacuum the db at" >> /tmp/vacuumdb.out
6 8923 tao
echo `date` >> /tmp/vacuumdb.out
7 8922 tao
su - postgres /usr/lib/postgresql/$DB_VERSION/bin/vacuumdb --all >> /tmp/vacuumdb.out 2> /tmp/vacuumdb.err < /dev/null
8
echo "start to vacuum the db at " >> /tmp/vacuumdb.out
9
echo `date` >>  /tmp/vacuumdb.out