diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-01-08 20:32:27 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-01-08 20:32:27 +0000 |
| commit | bf74477b05d42880270a9c31534fd743974998d2 (patch) | |
| tree | c7b5e19f152a827aa86c47dfd5109fcf5d13b2a4 /src | |
| parent | b95f81a54a0c7fd87052d77f5401192a2bb87d6d (diff) | |
| download | postgresql-bf74477b05d42880270a9c31534fd743974998d2.tar.gz postgresql-bf74477b05d42880270a9c31534fd743974998d2.zip | |
check for failure after vacuuming each DB, not only the last one.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/scripts/vacuumdb | 13 |
1 files changed, 6 insertions, 7 deletions
diff --git a/src/bin/scripts/vacuumdb b/src/bin/scripts/vacuumdb index 9b310327a1f..3bd005445a8 100644 --- a/src/bin/scripts/vacuumdb +++ b/src/bin/scripts/vacuumdb @@ -11,7 +11,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.13 2000/11/25 19:05:44 petere Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.14 2001/01/08 20:32:27 tgl Exp $ # #------------------------------------------------------------------------- @@ -145,7 +145,7 @@ if [ "$alldb" ]; then dbname=`${PATHNAME}psql $PSQLOPT -q -t -A -d template1 -c 'SELECT datname FROM pg_database'` elif [ -z "$dbname" ]; then - echo "$CMDNAME: missing required argument database name" 1>&2 + echo "$CMDNAME: missing required argument: database name" 1>&2 echo "Try '$CMDNAME -?' for help." 1>&2 exit 1 fi @@ -154,11 +154,10 @@ for db in $dbname do [ "$alldb" -a "$quiet" -ne 1 ] && echo "Vacuuming $db" ${PATHNAME}psql $PSQLOPT $ECHOOPT -c "VACUUM $verbose $analyze $table" -d $db + if [ $? -ne 0 ]; then + echo "$CMDNAME: vacuum $table $db failed" 1>&2 + exit 1 + fi done -if [ $? -ne 0 ]; then - echo "$CMDNAME: vacuum failed" 1>&2 - exit 1 -fi - exit 0 |