|
Hopefully, this page is exactly what you are looking for, but if not, you can always find further assistance on Unix/Linux Forum!
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(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
Application Last change: 2005-11-05 1
PostgreSQL Client Applications CLUSTERDB(1)
--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
Application Last change: 2005-11-05 2
PostgreSQL Client Applications CLUSTERDB(1)
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)
Application Last change: 2005-11-05 3
Man(1) output converted with
man2html and wrapped by fishsponge
This page was generated on Wed Sep 12 11:24:30 GMT 2007
|
Your favourite pages:
No pages logged yet.
Trying to save cookie... Top 10 most popular pages:
ssh man page (4011 hits)
(Suse Linux 10.1)
CPAN man page (3936 hits)
(Suse Linux 10.1)
startproc man page (1431 hits)
(Suse Linux 10.1)
svn man page (1147 hits)
(FreeBSD 6.2)
signal man page (1069 hits)
(Suse Linux 10.1)
lwptut man page (1033 hits)
(Suse Linux 10.1)
startpar man page (808 hits)
(Suse Linux 10.1)
netcat man page (796 hits)
(Suse Linux 10.1)
Net::Config man page (740 hits)
(Suse Linux 10.1)
oowriter man page (720 hits)
(Suse Linux 10.1)
|
Man Pages 
