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
#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##';"
#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"