04-30-2009
I am still writing the code. Yeah db name would be different but password is same for all DBs. I dont think we would be writing the pwd in the file.
I am new to unix so struggling a bit.
Kindly help or give me some hints so that i may also try that out by myself.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a few questions about Unix. Can you please help!
1.How do I create an alias that greps the password file for my username and returns my password file entry? Once I get the alias to work I want to be able to let a friend use it .So that he can use the alias to locate his password entry... (1 Reply)
Discussion started by: JJJ
1 Replies
2. UNIX for Dummies Questions & Answers
friends i wanted to now whehter there exists a book as a solution to the questions posted in exercies of the Design of Unix Operating system by Maurice J Bach !..its really urgent !! (1 Reply)
Discussion started by: darshaan
1 Replies
3. UNIX for Dummies Questions & Answers
hi friends,
How to obtain list of groups we r a member of and redirect it to a file.
how to append the details of current OS to a file.
how to append the estimated file space to a file.
how to append the details of users loged on along wth their current activity into a file.
Thank you...I'm... (3 Replies)
Discussion started by: bobby36
3 Replies
4. Shell Programming and Scripting
Hi All,
I have a Sqlplus report which will create a file.
I need a FTP Script that will be executed inside the Sqlplus Report to FTP the report output file to unix server.
Thanks,
Previn (0 Replies)
Discussion started by: vprevin
0 Replies
5. UNIX for Advanced & Expert Users
Hi All,
I need to find out the completed transactions count which happened during a particular time duration from a log file. I'm a newbie with scripts and i'm unable to figure out how to get this task done with scripts. I have a transaction log file which has various lines indicating the... (1 Reply)
Discussion started by: haran_3k
1 Replies
6. Shell Programming and Scripting
Hi,
I am new to Shell Scripting.
I need to pick the files from one directory and place them in another directory based on time stamp.It should pick the files if the files is not accessed for 1 hour.
Can any one please help me how to work on this.
Thanks in Advance.
Regards,
Prakash (1 Reply)
Discussion started by: kvrprakash
1 Replies
7. Homework & Coursework Questions
#!/bin/sh
#Buddy Gibbons
#COP3353 - Assignment 4
#4/21/12
file=$1
directories=0
files=0
rfiles=0
xfiles=0
wfiles=0
if
then
echo "Usage: assignment4.sh <directory_name>"
exit
fi (1 Reply)
Discussion started by: tennistennis1
1 Replies
8. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
2. Shell Bash Script
3.
!/bin/bash
if
echo no directory
then
mkdir -p /home/AC_Drywall
elif ; then
echo "$dir already exist"
fi (4 Replies)
Discussion started by: TomFord1
4 Replies
9. Shell Programming and Scripting
Hi All,
Its urgent.. pls help me out.. I want to create a KSH which should generate a report with the list of users and the files larger than 5 GB created by them in a direcorty and send autogenerated e-mail to them.
my input would be users list,directory path and the file size (say 5 GB)
... (11 Replies)
Discussion started by: anman0523
11 Replies
10. Shell Programming and Scripting
hi guys,
i need a script to sftp the file from windows to unix server ....(before that i have to check whether the file exists in the windows server or not
and again i have to reverse sftp the files from unix to windows server.....
regards,
Vasa Saikumar. (13 Replies)
Discussion started by: hemanthsaikumar
13 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)