|
11 | 11 | #
|
12 | 12 | #
|
13 | 13 | # IDENTIFICATION
|
14 |
| -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.14 2001/01/0820:32:27 tgl Exp $ |
| 14 | +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.15 2001/01/0823:02:36 tgl Exp $ |
15 | 15 | #
|
16 | 16 | #-------------------------------------------------------------------------
|
17 | 17 |
|
@@ -142,7 +142,7 @@ if [ "$alldb" ]; then
|
142 | 142 | echo"$CMDNAME: cannot vacuum all databases and a specific one at the same time"1>&2
|
143 | 143 | exit 1
|
144 | 144 | fi
|
145 |
| -dbname=`${PATHNAME}psql$PSQLOPT -q -t -A -d template1 -c'SELECT datname FROM pg_database'` |
| 145 | +dbname=`${PATHNAME}psql$PSQLOPT -q -t -A -d template1 -c'SELECT datname FROM pg_database WHERE datallowconn'` |
146 | 146 |
|
147 | 147 | elif [-z"$dbname" ];then
|
148 | 148 | echo"$CMDNAME: missing required argument: database name"1>&2
|
|