Advertisement
Guest User

Untitled

a guest
Feb 19th, 2014
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.53 KB | None | 0 0
  1. # grab record id's from staging table
  2. psql -d evergreen -A -t -c 'SELECT id FROM staging_records_import;' > recids.sql
  3.  
  4. # convert the list of id's into SQL INSERTs
  5. sed -i 's/^\(.*\)$/INSERT INTO biblio.record_entry (marc) SELECT marc FROM staging_records_import WHERE id = $1;/' recids.sql
  6.  
  7. # split record id's into 4 files (so you can parallelize the import)
  8. split -d -n l/4 recids.sql recids.sql.
  9.  
  10. # now, use a separate psql process for each resulting file (recids.sql.00, recids.sql.01, etc)
  11. psql -d evergreen -f recids.sql.00
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement