05-24-2001
Anyone know how to automate the Unzip password prompt?
I need to unzip a window's file in Unix without manually
typing in the password.
9 More Discussions You Might Find Interesting
1. Solaris
Hi,
We've gotta bit of a problem regarding backups. Sometimes when we run a backup from a script :
find . -print |grep -v "^\.\/newicc" | grep -v "^\.\/proc" >$LST
cat $LST | cpio -oBcav > /dev/rmt/1cb
It quite often it seems to hang when it reaches the /etc/magic file. This happens... (2 Replies)
Discussion started by: PaulC
2 Replies
2. What is on Your Mind?
Dear UNIX Folks,
I guess everyone of us like to know what sysadmin typically do during his free time.
Not what he/she likes as an hobbies.. but what activities does he/she often indulge in other than facing the monitor.
Maybe we can come up this a better stereo-typed for sysadmin.
I... (8 Replies)
Discussion started by: izy100
8 Replies
3. HP-UX
Hi All
I have ftped a .ZIP file (zipped using WinZip in Windows) to my Unix server (HP-UX).
I don't have unzip cmd available in my curent Unix version
Please let me know any cmd in UNIX (other than unzip) using which I can unzip this .ZIP file .
Please elaborate on the commands aval and... (5 Replies)
Discussion started by: sureshg_sampat
5 Replies
4. Shell Programming and Scripting
Hey guys,
I need to unzip a file zipped using winzip 11.1 strong encryption method (send by our vendor) with password. We use AIX unix.
I tried "unzip -P pw filename.zip" But gives error
Archive: filename.zip
skipping: filename/abc.idx unsupported compression method 99
get this... (2 Replies)
Discussion started by: JKN
2 Replies
5. Shell Programming and Scripting
Hi All
I have ftped a .ZIP file (zipped using WinZip in Windows) to my Unix server (HP-UX).
I don't have unzip cmd available in my curent Unix version
Please let me know any cmd in UNIX (other than unzip) using which I can unzip this .ZIP file .
Please elaborate on the commands aval and... (5 Replies)
Discussion started by: sureshg_sampat
5 Replies
6. Shell Programming and Scripting
i am asking to do somethings like:
make use of 2 environment variables:
ASS1_DATA_DIR specifies the location of the input data files
ASS1_OUTPUT_DIR specifies the location of the output data files
i have something like that;
#set environment variables
set
VARIABLE1=ASS1_DATA_DIR... (5 Replies)
Discussion started by: mingming88
5 Replies
7. Shell Programming and Scripting
Hi,
I need to zip/compress a data file and send to a vendor. The vendor does have only unzip utility and can accept only .ZIP files. I do not have zip utility in my server.
How do I zip/compress the file so that it can be deflated using unzip command ? I tried gzip & compress commands, but... (1 Reply)
Discussion started by: Sabari Nath S
1 Replies
8. Shell Programming and Scripting
I have .zip file, i want to list all the files archived in the zip file. unzip utility is not working for me in unix.
Please help me resolve this issue
Thanks
ganesh. (3 Replies)
Discussion started by: Ganesh L
3 Replies
9. Forum Support Area for Unregistered Users & Account Problems
I was unable to login and so used the "Forgotten Password' process. I was sent a NEWLY-PROVIDED password and a link through which my password could be changed. The NEWLY-PROVIDED password allowed me to login.
Following the provided link I attempted to update my password to one of my own... (1 Reply)
Discussion started by: Rich Marton
1 Replies
LEARN ABOUT OSX
clusterdb
CLUSTERDB(1) PostgreSQL Client Applications CLUSTERDB(1)
NAME
clusterdb - cluster a PostgreSQL database
SYNOPSIS
clusterdb [ connection-option... ] [ [ --verbose ] [ -v ] ] [ --table | -t table ] [ dbname ]
clusterdb [ connection-option... ] [ [ --all ] [ -a ] ] [ [ --verbose ] [ -v ] ]
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 affected.
clusterdb is a wrapper around the SQL command CLUSTER [cluster(7)]. There is no effective difference between clustering 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 progress messages.
-t table
--table table
Cluster table only.
-v
--verbose
Print detailed information during processing.
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
--no-password
Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as
a .pgpass file, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to
enter a password.
-W
--password
Force clusterdb to prompt for a password before connecting to a database.
This option is never essential, since clusterdb will automatically prompt for a password if the server demands password authentica-
tion. However, clusterdb will waste a connection attempt finding out that the server wants a password. In some cases it is worth
typing -W to avoid the extra connection attempt.
ENVIRONMENT
PGDATABASE
PGHOST
PGPORT
PGUSER Default connection parameters
This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see in the documentation).
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 variables 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)]
Application 2010-05-14 CLUSTERDB(1)