Unix‎ > ‎Solaris‎ > ‎Solaris man pages‎ > ‎1‎ > ‎

clusterdb


NAME
     clusterdb - cluster a PostgreSQL database


SYNOPSIS
     clusterdb [ connection-option... ]  [ --table | -t table   ]
     [ dbname ]

     clusterdb [ connection-option... ]  [  [ --all ]  [ -a ]  ]

DESCRIPTION
     clusterdb is a utility for reclustering tables  in  a  Post-
     greSQL  database.  It finds tables that have previously been
     clustered, and clusters them again on the  same  index  that
     was last used. Tables that have never been clustered are not
     affected.

     clusterdb is a wrapper around the SQL command CLUSTER [clus-
     ter(5)].   There is no effective difference between cluster-
     ing databases via this utility and  via  other  methods  for
     accessing the server.

OPTIONS
     clusterdb accepts the following command-line arguments:

     -a

     --all
          Cluster all databases.

     [-d] dbname

     [--dbname] dbname
          Specifies the name of the database to be clustered.  If
          this  is  not  specified and -a (or --all) is not used,
          the database name is read from the environment variable
          PGDATABASE. If that is not set, the user name specified
          for the connection is used.

     -e

     --echo
          Echo the commands that clusterdb generates and sends to
          the server.

     -q

     --quiet
          Do not display a response.

     -t table

     --table table
          Cluster table only.

     clusterdb also accepts the following command-line  arguments
     for connection parameters:

     -h host

     --host host
          Specifies the host name of the  machine  on  which  the
          server is running. If the value begins with a slash, it
          is used as the directory for the Unix domain socket.

     -p port

     --port port
          Specifies the TCP port or local Unix domain socket file
          extension  on which the server is listening for connec-
          tions.

     -U username

     --username username
          User name to connect as.

     -W

     --password
          Force password prompt.

ENVIRONMENT
     PGDATABASE

     PGHOST

     PGPORT

     PGUSER
          Default connection parameters

DIAGNOSTICS
     In case of difficulty, see CLUSTER [cluster(5)] and  psql(1)
     for  discussions  of  potential problems and error messages.
     The database server must be running at  the  targeted  host.
     Also,  any default connection settings and environment vari-
     ables used by the libpq front-end library will apply.

EXAMPLES
     To cluster the database test:

     $ clusterdb test

     To cluster a single table foo in a database named xyzzy:

     $ clusterdb --table foo xyzzy


SEE ALSO
     CLUSTER [cluster(5)], Environment Variables (the  documenta-
     tion)










Man pages from Solaris 10 Update 8. See docs.sun.com and www.oracle.com for further documentation and Solaris information.
Comments