Project

General

Profile

1
#!/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
echo `date` >> /tmp/vacuumdb.out
7
su - postgres  -c "/usr/lib/postgresql/$DB_VERSION/bin/vacuumdb --all >> /tmp/vacuumdb.out 2> /tmp/vacuumdb.err < /dev/null"
8
echo "end to vacuum the db at " >> /tmp/vacuumdb.out
9
echo `date` >>  /tmp/vacuumdb.out
(12-12/12)