update PG host in MARC export scripts master
authorJeff Davis <jdavis@sitka.bclibraries.ca>
Fri, 3 Dec 2021 00:02:25 +0000 (16:02 -0800)
committerJeff Davis <jdavis@sitka.bclibraries.ca>
Fri, 3 Dec 2021 00:02:25 +0000 (16:02 -0800)
marc_export_custom/fetch-shortcodes.sh
marc_export_custom/mucn-ebsco-full-export-parallel.sh
marc_export_custom/sitka-full-export-parallel.sh

index 4c91014..a32c047 100755 (executable)
@@ -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
index adc4996..7cf2543 100755 (executable)
@@ -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##';"
index fcc8a44..4c2c397 100755 (executable)
@@ -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"