Revision 8922
Added by Jing Tao about 10 years ago
| src/scripts/bash/vacuum-db.sh | ||
|---|---|---|
| 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` |
|
| 7 |
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 |
|
Also available in: Unified diff
A script for vacuum the db.