10 More Discussions You Might Find Interesting
1. SuSE
Dear users,
SUSE 10 sp3 and SUSE 11.
I made configuration changes in '/etc/syslog-ng/syslog-ng.conf'
to move SYSLOG content to LogRhythm.
This is what I changed in the file.
Un-comment out the following lines
#Enable this and admop IP to send log messages to... (10 Replies)
Discussion started by: JDBA
10 Replies
2. Shell Programming and Scripting
I need to collect last 2 days data from /var/log/messages into a separate file (file format: flmessagetimedaymonth). I have collect today's month, date, time information in separate variable. Please help me in this issue (Probably need awk and grep function).
month=$(date|awk '{print $2}')... (4 Replies)
Discussion started by: makauser
4 Replies
3. Shell Programming and Scripting
Hi all,
i have a task to do with Python and because i'm a beginner on it i would like your help on this.
Create a python script that:
Every hour collect the Temperature (e.g. 29C) and Current Condition (e.g. Clear) from this website wunderground.com/global/stations/54511.html
Create a CSV... (0 Replies)
Discussion started by: ragaga123
0 Replies
4. Shell Programming and Scripting
Hi, I'm newbie in Korn scripting as well as in Unix. I need to have a script to do the following.
1) ssh multiple hosts
-In my case, login credentials are not an issue as all keys authorized by default. Example of host IP (24.35.14.6, 24.35.14.7, 24.35.14.8, 24.35.14.9, ... (2 Replies)
Discussion started by: blinkingdan
2 Replies
5. UNIX Desktop Questions & Answers
there are 200 files named file1_0.pdb,file1_60.pdb etc....it looks like:
ATOM 1 N VAL 1 8.897 -21.545 -7.276 1.00 0.00
ATOM 2 H1 VAL 1 9.692 -22.015 -6.868 1.00 0.00
ATOM 3 H2 VAL 1 9.228 -20.766 -7.827 1.00 0.00
ATOM 4 H3 ... (5 Replies)
Discussion started by: kanikasharma
5 Replies
6. Shell Programming and Scripting
I have a file current.csv file
2011/05/06 11:12:20 | 16:guest pid=014782 opened Boards 0, 1, 2, 3
2011/05/06 12:23:13 | 16:guest pid=014782 closed
2011/05/06 12:26:05 | 17:guest pid=022383 opened Boards 0, 1, 2, 3
2011/05/06 20:09:04 | 17:guest pid=022383 closed
2011/05/06... (5 Replies)
Discussion started by: sabercats
5 Replies
7. Web Development
If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries
LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n' (0 Replies)
Discussion started by: sitex
0 Replies
8. Shell Programming and Scripting
Hi All,
I need to convert the data from excel to database table in sybase. Please provide some sample script..
thanks,
Royal. (1 Reply)
Discussion started by: royal9482
1 Replies
9. UNIX for Dummies Questions & Answers
hi
I am very new to UNIX.
I need to retrieve data from a unix system and store it and display as output on a windows system.
Initiation of procedure is through JAVASCRIPT-based buttons on a HTML page.
This should cause a set of commands to run which colllect data from a unix based server and... (1 Reply)
Discussion started by: rossalyn_maxter
1 Replies
10. Shell Programming and Scripting
Hi Friends ,
I am urgently needed your help.
could you pleas help me in creating the shell script.
Requirement :
collect the data from no_file.txt
no_file.txt
============
1
11
265
290
300
313
326
351
Then create another shele script like
my_shell.csh (3 Replies)
Discussion started by: bikas_jena
3 Replies
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)