From 7be6641d2460141286f16bbaba32bde3569d4cbd Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Mon, 19 Oct 2015 17:57:59 -0400
Subject: [PATCH] adding host parameter

---
 get_circ_history.sh | 3 ++-
 get_hold_history.sh | 3 ++-
 2 files changed, 4 insertions(+), 2 deletions(-)

diff --git a/get_circ_history.sh b/get_circ_history.sh
index 4cba791..d30155f 100755
--- a/get_circ_history.sh
+++ b/get_circ_history.sh
@@ -20,6 +20,7 @@ done
 
 # Note: it is assumed that you're using .pgpass here
 PSQL="/usr/bin/psql"
+PSQL_HOST="mydbhost"
 PSQL_USER="evergreen"
 PSQL_DB="evergreen"
 
@@ -93,4 +94,4 @@ EOF
 #echo "\$BARCODE = $BARCODE, \$LIMIT = $LIMIT"
 #echo $SQL
 
-$PSQL -U "$PSQL_USER" -d "$PSQL_DB" -P null="<NULL>" -x -c "$SQL"
+$PSQL -U "$PSQL_USER" -h "$PSQL_HOST" -d "$PSQL_DB" -P null="<NULL>" -x -c "$SQL"
diff --git a/get_hold_history.sh b/get_hold_history.sh
index 199ec45..ff3ca15 100755
--- a/get_hold_history.sh
+++ b/get_hold_history.sh
@@ -20,6 +20,7 @@ done
 
 # Note: it is assumed that you're using .pgpass here
 PSQL="/usr/bin/psql"
+PSQL_HOST="mydbhost"
 PSQL_USER="evergreen"
 PSQL_DB="evergreen"
 
@@ -114,4 +115,4 @@ EOF
 #echo "\$USER_BARCODE = $USER_BARCODE, \$ITEM_BARCODE = $ITEM_BARCODE, \$LIMIT = $LIMIT"
 #echo $SQL
 
-$PSQL -U "$PSQL_USER" -d "$PSQL_DB" -P null="<NULL>" -x -c "$SQL"
+$PSQL -U "$PSQL_USER" -h "$PSQL_HOST" -d "$PSQL_DB" -P null="<NULL>" -x -c "$SQL"
-- 
2.11.0