Revision 8925
Added by Jing Tao about 10 years ago
src/scripts/bash/vacuum-db.sh | ||
---|---|---|
1 | 1 |
#!/bin/bash |
2 | 2 |
#A script to vacuum the db. |
3 | 3 |
#Usage: nohup ./ |
4 |
DB_VERSION=9.3 |
|
5 | 4 |
echo "start to vacuum the db at" >> /tmp/vacuumdb.out |
6 | 5 |
echo `date` >> /tmp/vacuumdb.out |
7 |
su - postgres /usr/lib/postgresql/$DB_VERSION/bin/vacuumdb --all >> /tmp/vacuumdb.out 2> /tmp/vacuumdb.err < /dev/null
|
|
6 |
su - postgres /usr/lib/postgresql/9.3/bin/vacuumdb --all >> /tmp/vacuumdb.out 2> /tmp/vacuumdb.err < /dev/null
|
|
8 | 7 |
echo "end to vacuum the db at " >> /tmp/vacuumdb.out |
9 | 8 |
echo `date` >> /tmp/vacuumdb.out |
Also available in: Unified diff
Use the version directly.