Commitbf74477

committed

check for failure after vacuuming each DB, not only the last one.

1 parentb95f81a commitbf74477Copy full SHA for bf74477

File tree

-7

lines changed

-7

lines changed

Lines changed: 6 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -11,7 +11,7 @@`
`11`	`11`	`#`
`12`	`12`	`#`
`13`	`13`	`# IDENTIFICATION`
`14`		`-# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.13 2000/11/25 19:05:44 petere Exp $`
	`14`	`+# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.14 2001/01/08 20:32:27 tgl Exp $`
`15`	`15`	`#`
`16`	`16`	`#-------------------------------------------------------------------------`
`17`	`17`
`@@ -145,7 +145,7 @@ if [ "$alldb" ]; then`
`145`	`145`	dbname=`${PATHNAME}psql$PSQLOPT -q -t -A -d template1 -c'SELECT datname FROM pg_database'`
`146`	`146`
`147`	`147`	`elif [-z"$dbname" ];then`
`148`		`-echo"$CMDNAME: missing required argument database name"1>&2`
	`148`	`+echo"$CMDNAME: missing required argument: database name"1>&2`
`149`	`149`	`echo"Try '$CMDNAME -?' for help."1>&2`
`150`	`150`	`exit 1`
`151`	`151`	`fi`
`@@ -154,11 +154,10 @@ for db in $dbname`
`154`	`154`	`do`
`155`	`155`	`["$alldb"-a"$quiet"-ne 1 ]&&echo"Vacuuming$db"`
`156`	`156`	`${PATHNAME}psql$PSQLOPT$ECHOOPT -c"VACUUM$verbose$analyze$table" -d$db`
	`157`	`+if [$?-ne 0 ];then`
	`158`	`+echo"$CMDNAME: vacuum$table$db failed"1>&2`
	`159`	`+exit 1`
	`160`	`+fi`
`157`	`161`	`done`
`158`	`162`
`159`		`-if [$?-ne 0 ];then`
`160`		`-echo"$CMDNAME: vacuum failed"1>&2`
`161`		`-exit 1`
`162`		`-fi`
`163`		`-`
`164`	`163`	`exit 0`

Comments

(0)