We need access to the following tables from each CN's Metacat databases:
Enable transfer of these tables to the controlling host (likely via pg_dump), and load these tables into Metacat on the controlling host (likely via pg_restore), using table name prefixes (like unm_, orc_, ucsb_) to discern the CN source among the tables.
#1 Updated by Chris Jones almost 10 years ago
I've written scripts (~postgres/tx_sysmeta/tx_sysmeta_tables.sh) on all 3 production CNs that use pg_dump to dump the database tables. The scripts use sed to replace DDL statements and add table prefixes (unm_, orc_, ucsb_) in the SQL dump files, and then use rsync over ssh with cert-based auth to transfer the bulk data to the controlling machine. At the moment, it is sending the SQL data to cn-sandbox-unm-1 while testing.