Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit1c22576

Browse files
committed
> > It would be nice for new users; I think it would make it easier> > for them to actually set out and do it. Many new users are> > of the not-so-knowledgable variety, and shell scripting isn't> > something they want to undertake.>> Can someone modify the vacuumdb shell script to do that?i tried it... it seems to workneko@kredit.sth.sz
1 parentfd96e17 commit1c22576

File tree

2 files changed

+21
-5
lines changed

2 files changed

+21
-5
lines changed

‎doc/src/sgml/ref/vacuumdb.sgml‎

Lines changed: 11 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/vacuumdb.sgml,v 1.6 1999/12/07 22:41:41 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/vacuumdb.sgml,v 1.7 1999/12/18 08:34:49 momjian Exp $
33
Postgres documentation
44
-->
55

@@ -23,7 +23,7 @@ Postgres documentation
2323
<date>1999-12-04</date>
2424
</refsynopsisdivinfo>
2525
<synopsis>
26-
vacuumdb [ <replaceable class="parameter">connection options</replaceable> ] [ --analyze | -z ] [ --verbose | -v ]
26+
vacuumdb [ <replaceable class="parameter">connection options</replaceable> ] [ --analyze | -z ] [ --alldb | -a ] [ --verbose | -v ]
2727
[ --table '<replaceable class="parameter">table</replaceable> [ ( <replaceable class="parameter">column</replaceable> [,...] ) ]' ] [ [-d] <replaceable class="parameter">dbname</replaceable> ]
2828
</synopsis>
2929

@@ -56,6 +56,15 @@ vacuumdb [ <replaceable class="parameter">connection options</replaceable> ] [ -
5656
</listitem>
5757
</varlistentry>
5858

59+
<varlistentry>
60+
<term>-a, --alldb</term>
61+
<listitem>
62+
<para>
63+
Vacuum all databases.
64+
</para>
65+
</listitem>
66+
</varlistentry>
67+
5968
<varlistentry>
6069
<term>-v, --verbose</term>
6170
<listitem>

‎src/bin/scripts/vacuumdb‎

Lines changed: 10 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -11,7 +11,7 @@
1111
#
1212
#
1313
# IDENTIFICATION
14-
# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.4 1999/12/16 20:10:02 momjian Exp $
14+
# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.5 1999/12/18 08:34:50 momjian Exp $
1515
#
1616
#-------------------------------------------------------------------------
1717

@@ -39,6 +39,8 @@ do
3939
--host=*)
4040
PSQLOPT="$PSQLOPT -h"`echo$1| sed's/^--host=//'`
4141
;;
42+
--alldb|-a)
43+
dbname="`psql$PASSWDOPT$AUTHOPT$PGHOSTOPT$PGPORTOPT -q -t -A -d template1 -c'SELECT datname FROM pg_database'`";;
4244
--port|-p)
4345
PSQLOPT="$PSQLOPT -p$2"
4446
shift;;
@@ -119,6 +121,7 @@ if [ "$usage" ]; then
119121
echo" -W, --password"
120122
echo" -d DBNAME, --database=DBNAME"
121123
echo" -z, --analyze"
124+
echo" -a, --alldb"
122125
echo" -t TABLE[(columns)], --table=TABLE[(columns)]"
123126
echo" -v, --verbose"
124127
echo" -e, --echo"
@@ -133,9 +136,13 @@ if [ -z "$dbname" ]; then
133136
exit 1
134137
fi
135138

136-
psql$PSQLOPT -d"$dbname" -c"VACUUM$verbose$analyze$table"
139+
fordbin$dbname
140+
do
141+
psql$PASSWDOPT -tq$AUTHOPT$PGHOSTOPT$PGPORTOPT -c"vacuum$verbose$analyze$table"$db
142+
done
137143

138-
if [$?-ne 0 ];then
144+
if [$?-ne 0 ]
145+
then
139146
echo"$CMDNAME: Vacuum failed."
140147
exit 1
141148
fi

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp