From: Jeff Davis <jdavis@sitka.bclibraries.ca>
Date: Fri, 3 Dec 2021 00:02:25 +0000 (-0800)
Subject: update PG host in MARC export scripts
X-Git-Url: https://git.sitka.bclibraries.ca/gitweb/?p=sitka%2Fsitka-tools.git;a=commitdiff_plain;h=278f5edbfe72fe9dc0d2b7ac9a0167334dc1dfb6

update PG host in MARC export scripts
---

diff --git a/marc_export_custom/fetch-shortcodes.sh b/marc_export_custom/fetch-shortcodes.sh
index 4c91014..a32c047 100755
--- a/marc_export_custom/fetch-shortcodes.sh
+++ b/marc_export_custom/fetch-shortcodes.sh
@@ -3,7 +3,7 @@ SHORTCODES=$1
 if [ -z "${SHORTCODES}" ]; then
     SHORTCODES="shortcodes.csv"
 fi
-psql -Upostgres -U evergreen evergreen -h dbprod-96-main-ndb2 -o $SHORTCODES \
+psql -Upostgres -U evergreen evergreen -h prod-pg96-db2-sitka -o $SHORTCODES \
 -c "COPY (
       SELECT
         a.shortname,a.name,b.shortname AS parent
diff --git a/marc_export_custom/mucn-ebsco-full-export-parallel.sh b/marc_export_custom/mucn-ebsco-full-export-parallel.sh
index adc4996..7cf2543 100755
--- a/marc_export_custom/mucn-ebsco-full-export-parallel.sh
+++ b/marc_export_custom/mucn-ebsco-full-export-parallel.sh
@@ -4,7 +4,7 @@ DIR=$(readlink -f $(dirname $0))
 #cd /srv/openils/bin
 
 PGUSER=evergreen
-PGHOST=dbprod-96-main-ndb2
+PGHOST=prod-pg96-db2-sitka
 PSQL="psql -A -t -U $PGUSER -h $PGHOST"
 DATABASE=evergreen
 MUCN_QUERY="select distinct record FROM asset.call_number where owning_lib in (select distinct id from actor.org_unit_descendants(1400)) and not deleted and label != '##URI##';"
diff --git a/marc_export_custom/sitka-full-export-parallel.sh b/marc_export_custom/sitka-full-export-parallel.sh
index fcc8a44..4c2c397 100755
--- a/marc_export_custom/sitka-full-export-parallel.sh
+++ b/marc_export_custom/sitka-full-export-parallel.sh
@@ -4,7 +4,7 @@ DIR=$(readlink -f $(dirname $0))
 #cd /srv/openils/bin
 
 PGUSER=evergreen
-PGHOST=dbprod-96-main-ndb2
+PGHOST=prod-pg96-db2-sitka
 PSQL="psql -A -t -U $PGUSER -h $PGHOST"
 DATABASE=evergreen
 #FULL_QUERY="select distinct id from biblio.record_entry where not deleted"