Filewatcher File Search File Search
Catalog
Content Search
» » » » » » postgresql-8.1.23-1.el5_7.3.i386.rpm » Content »
pkg://postgresql-8.1.23-1.el5_7.3.i386.rpm:3009475/usr/share/man/man1/  info  HEADER  downloads

postgresql - PostgreSQL client programs and libraries.…  more info»

clusterdb.1.gz

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  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(7)].  There is no effective difference between clustering
       databases via this utility and via other methods for  access‐
       ing 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
              connections.

       -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(7)]  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(7)], Environment Variables  (the  documenta‐
       tion)



Application                  2010-12-14                 CLUSTERDB(1)
Results 1 - 1 of 1
Help - FTP Sites List - Software Dir.
Search over 15 billion files
© 1997-2017 FileWatcher.com