clusterdb man page on Scientific

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

CLUSTERDB(1)		PostgreSQL Client Applications		  CLUSTERDB(1)

       clusterdb - cluster a PostgreSQL database

       clusterdb  [  connection-option...  ]   [   [ --verbose ]  [ -v ]  ]  [
       --table | -t table  ]  [ dbname ]

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

       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(7)].
       There  is no effective difference between clustering databases via this
       utility and via other methods for accessing the server.

       clusterdb accepts the following command-line arguments:


       --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.


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


	      Do not display progress messages.

       -t table

       --table table
	      Cluster table only.


	      Print detailed information during processing.

       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.


	      Never issue a password prompt. If the server  requires  password
	      authentication  and  a  password is not available by other means
	      such as a .pgpass file, the connection attempt will  fail.  This
	      option  can be useful in batch jobs and scripts where no user is
	      present to enter a password.


	      Force clusterdb to prompt for a password before connecting to  a

	      This  option  is never essential, since clusterdb will automati‐
	      cally prompt for a  password  if	the  server  demands  password
	      authentication.	However,  clusterdb  will  waste  a connection
	      attempt finding out that the server wants a password.   In  some
	      cases  it	 is  worth  typing  -W	to  avoid the extra connection




       PGUSER Default connection parameters

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

       In case of difficulty, see CLUSTER [cluster(7)] 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.

       To cluster the database test:

       $ clusterdb test

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

       $ clusterdb --table foo xyzzy

       CLUSTER [cluster(7)]

Application			  2013-10-08			  CLUSTERDB(1)

List of man pages available for Scientific

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]
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