clusterdb man page on OpenServer

Man page or keyword search:  
man Server   5388 pages
apropos Keyword Search (all sections)
Output format
OpenServer logo
[printable version]

CLUSTERDB(1)		PostgreSQL Client Applications		  CLUSTERDB(1)

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  PostgreSQL	 data-
       base. 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 [cluster(5)].
       There is no effective difference between clustering 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 connec-
       tion 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	exten-
	      sion on which the server is listening for connections.

       -U username

       --username username
	      User name to connect as.

       -W

       --password
	      Force password prompt.

ENVIRONMENT
       PGDATABASE

       PGHOST

       PGPORT

       PGUSER Default connection parameters

       This utility, like most other PostgreSQL utilities, also uses the envi-
       ronment variables supported by libpq (see in the documentation).

DIAGNOSTICS
       In case of difficulty, see CLUSTER [cluster(5)] and psql(1) for discus-
       sions  of  potential  problems and error messages.  The database server
       must be running at the targeted host. Also, any default connection set-
       tings  and  environment	variables  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)]

Application			  2008-06-08			  CLUSTERDB(1)
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server OpenServer

List of man pages available for OpenServer

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net