11-11-2013
There are commands... But the syntax is depending on the version of the installed cluster software. So you need to check the documentation to find the commands you need.
An appendix about commands on cluster 3.2 is here:
http://docs.oracle.com/cd/E19787-01/...mam/index.html
But there are newer versions like 3.3 and 4.0 and also older versions which use completly different commands. I recommend to use the
Oracle Explorer (a tool to gather information about your system) and "grep" the information you need from the output of this tool. This is a lot easier than to write a script...
9 More Discussions You Might Find Interesting
1. Linux
hey we doing a clean up here at work and throwing out all the old PC's. Not the best like 300Mhz or around there they are.
I've grab a few since I would like to teach myself how to cluster! Only one thing. I got no idea where to start.
I know do a search on google etc. But I was wondering... (3 Replies)
Discussion started by: woofie
3 Replies
2. AIX
Hi All
I have two Pseries servers with AIX 5L as operating systems. HACMP cluster was there. For some reasons I have to change IP addresses of Servers. So How could I do it?
Ajay (2 Replies)
Discussion started by: ajay234
2 Replies
3. High Performance Computing
Provides a description of how to set up a Solaris Cluster Express cluster in a VirtualBox on OpenSolaris.
More... (0 Replies)
Discussion started by: Linux Bot
0 Replies
4. High Performance Computing
Dear All,
Can anyone explain about Pros and Cons of SUN and Veritas Cluster ?
Any comparison chart is highly appreciated.
Regards,
RAA (4 Replies)
Discussion started by: RAA
4 Replies
5. High Performance Computing
Hi everyone,
I need to implement a cluster solution and i have no idea how to do it, we have 10 servers with quad core and high computation is our goal, please any documentation would be appreciated and also i am thinking of getting a HPC software from to redhat to implement it, i need your... (2 Replies)
Discussion started by: bensen
2 Replies
6. Solaris
Yesterday my customer told me to expect a vcs upgrade to happen in the future. He also plans to stop using HDS and move to EMC.
Am thinking how to migrate to sun cluster setup instead.
My plan as follows leave the existing vcs intact as a fallback plan.
Then install and build suncluster on... (5 Replies)
Discussion started by: sparcguy
5 Replies
7. UNIX for Dummies Questions & Answers
Hi friends pls give be a brief definition about clusters , i heard abt it its a server isnt any one have idea abt it
how to form a cluster ?
whts the configuration need for comning a cluster ?
wht os they used in it ?
How many servers can installed in a cluster ?
give me full detailes abt... (1 Reply)
Discussion started by: babinlonston
1 Replies
8. Solaris
Hello experts -
I am planning to install a Sun cluster 4.0 zone cluster fail-over. few basic doubts.
(1) Where should i install the cluster s/w binaries ?. ( global zone or the container zone where i am planning to install the zone fail-over)
(2) Or should i perform the installation on... (0 Replies)
Discussion started by: NVA
0 Replies
9. Solaris
I have two servers which are working active active (cluster).
my problem is :
When I put the following command :hastat -a to know the active node I have this message:"could not detect active node"
NB:the version of my solaris is 10 8/07 s10x_u4wos_12h x86
How to solve this problem
... (0 Replies)
Discussion started by: zineb06
0 Replies
LEARN ABOUT REDHAT
clusterdb
CLUSTERDB(1) PostgreSQL Client Applications CLUSTERDB(1)
NAME
clusterdb - cluster a PostgreSQL database
SYNOPSIS
clusterdb [ connection-options... ] [ --table | -t table ] [ dbname ]
clusterdb [ connection-options... ] [ --all | -a ]
DESCRIPTION
clusterdb is a utility for reclustering tables in a PostgreSQL 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 touched.
clusterdb is a shell script wrapper around the backend command CLUSTER [cluster(7)] via the PostgreSQL interactive terminal psql(1). There
is no effective difference between clustering databases via this or other methods. psql must be found by the script and a database server
must be running at the targeted host. Also, any default settings and environment variables available to psql and the libpq front-end
library do apply.
clusterdb might need to connect several times to the PostgreSQL server, asking for a password each time. It is convenient to have a
$HOME/.pgpass file in such cases.
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
Clusters 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 host begins with a slash, it is used as the directory for
the Unix domain socket.
-p port
--port port
Specifies the Internet TCP/IP 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.
DIAGNOSTICS
CLUSTER
Everything went well.
clusterdb: Cluster failed.
Something went wrong. clusterdb is only a wrapper script. See CLUSTER [cluster(7)] and psql(1) for a detailed discussion of error
messages and potential problems. Note that this message may appear once per table to be clustered.
ENVIRONMENT
PGDATABASE
PGHOST
PGPORT
PGUSER Default connection parameters.
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)]
Application 2002-11-22 CLUSTERDB(1)