Changeset 3848 for TI01-discovery/branches/ingestAutomation-upgrade/database/create_database.sh

Timestamp:

07/05/08 10:08:55 (13 years ago)

Author:

cbyrom

Message:

Adjust create database script to allow specification of port - along with default setting.

File:

• TI01-discovery/branches/ingestAutomation-upgrade/database/create_database.sh (modified) (1 diff)

TI01-discovery/branches/ingestAutomation-upgrade/database/create_database.sh

@@ -1 +1 @@
 #!/bin/bash
 
-if [ $# -ne 3 ]
+if [ $# -lt 2 ]
 then
-         echo 1>&2 Usage: $0 username database hostname
+         echo 1>&2 Usage: $0 username database [hostname] [port]
+         echo 1>&2 - hostname defaults to 'localhost'
+         echo 1>&2 - port defaults to 5432
          exit 127
 fi
 
-dbOptions="-U $1 -d $2 -h $3"
+port="5432"
+if [ $# -gt 3 ]
+then
+        port=$4
+fi
+
+host="localhost"
+if [ $# -gt 2 ]
+then
+        host=$3
+fi
+
+dbOptions="-U $1 -d $2 -h $host -p $port"
 echo $dbOptions