diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-01-08 23:02:36 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-01-08 23:02:36 +0000 |
| commit | f19238e0272a4c701c22cb86fc0c5e95f0e52d45 (patch) | |
| tree | dddd2e4deaeb3ef7abd2ac7346f61513934abb33 | |
| parent | 10fb290acace1a5356a376e1f532fd8b7433fef9 (diff) | |
| download | postgresql-f19238e0272a4c701c22cb86fc0c5e95f0e52d45.tar.gz postgresql-f19238e0272a4c701c22cb86fc0c5e95f0e52d45.zip | |
Prevent vacuumdb from trying to vacuum template0.
| -rw-r--r-- | src/bin/scripts/vacuumdb | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/scripts/vacuumdb b/src/bin/scripts/vacuumdb index 3bd005445a8..78d310edd87 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.14 2001/01/08 20:32:27 tgl Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.15 2001/01/08 23:02:36 tgl Exp $ # #------------------------------------------------------------------------- @@ -142,7 +142,7 @@ if [ "$alldb" ]; then echo "$CMDNAME: cannot vacuum all databases and a specific one at the same time" 1>&2 exit 1 fi - dbname=`${PATHNAME}psql $PSQLOPT -q -t -A -d template1 -c 'SELECT datname FROM pg_database'` + dbname=`${PATHNAME}psql $PSQLOPT -q -t -A -d template1 -c 'SELECT datname FROM pg_database WHERE datallowconn'` elif [ -z "$dbname" ]; then echo "$CMDNAME: missing required argument: database name" 1>&2 |