<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/clusterdb.sgml,v 1.7 2003/02/19 04:06:28 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/clusterdb.sgml,v 1.8 2003/03/20 18:53:18 momjian Exp $

PostgreSQL documentation

-->

<para>

<application>clusterdb</application> is a shell script wrapper around the

backend command

<xref linkend="SQL-CLUSTER" endterm="SQL-CLUSTER-title"> via

<xref linkend="SQL-CLUSTER" endterm="sql-cluster-title"> via

the <productname>PostgreSQL</productname> interactive terminal

<xref linkend="APP-PSQL">. There is no effective

difference between clustering databases via this or other methods.

and the <application>libpq</application> front-end library do apply.

</para>

<para>

<application>clusterdb</application> might need to connect several

times to the <productname>PostgreSQL</productname> server, asking for

a password each time. It is convenient to have a

<filename>$HOME/.pgpass</> file in such cases.

</para>

</refsect1>

<listitem>

<para>

Something went wrong. <application>clusterdb</application> is only a wrapper

script. See <xref linkend="SQL-CLUSTER" endterm="SQL-CLUSTER-title">

script. See <xref linkend="SQL-CLUSTER" endterm="sql-cluster-title">

and <xref linkend="APP-PSQL"> for a detailed

discussion of error messages and potential problems. Note that this message

may appear once per table to be clustered.

discussion of error messages and potential problems.

</para>

</listitem>

</varlistentry>

["$alldb" ]&&echo"Clustering$db"

query="SELECT nspname, pg_class.relname, pg_class_2.relname FROM pg_class, pg_class AS pg_class_2 JOIN pg_namespace ON (pg_namespace.oid=relnamespace), pg_index WHERE pg_class.oid=pg_index.indrelid AND pg_class_2.oid=pg_index.indexrelid AND pg_index.indisclustered AND pg_class.relowner=(SELECT usesysid FROM pg_user WHERE usename=current_user)"

if [-z"$table" ];then

${PATHNAME}psql$PSQLOPT$ECHOOPT -c"SET autocommit TO 'on';CLUSTER" -d$db

["$?"-ne 0 ]&&exit 1

ifecho$table| grep -s'\.'2>&1>/dev/null

tbl=`echo$table| cut -d. -f2`

nspc=`echo$table| cut -d. -f1`

tables=`${PATHNAME}psql$db$PSQLOPT -F: -P format=unaligned -t -c"$query AND pg_class.relname='$tbl' AND nspname='$nspc'"`

tables=`${PATHNAME}psql$db$PSQLOPT -F: -P format=unaligned -t -c"$query AND pg_class.relname='$table'"`

query=

nspc=`echo$tabs| cut -d: -f1`

tab=`echo$tabs| cut -d: -f2`

idx=`echo$tabs| cut -d: -f3`

query="$query CLUSTER$idx ON$nspc.$tab;"

${PATHNAME}psql$PSQLOPT$ECHOOPT -c"SET autocommit TO 'on';$query" -d$db

if ["$?"-ne 0 ]

${PATHNAME}psql$PSQLOPT$ECHOOPT -c"SET autocommit TO 'on';CLUSTER$table" -d$db

["$?"-ne 0 ]&&exit 1