Advertisement
Guest User

Untitled

a guest
Feb 19th, 2017
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. export PGHOST=.....
  2. export PGUSER=citus
  3. export PGPASSWORD=....
  4. export PGSSLMODE=require
  5. export PGDATABASE=citus
  6. export TABLE_NAME=events
  7. export NEW_TABLE_NAME=events_backup
  8. export PARALLEL_FACTOR=4
  9.  
  10. psql -tA -F" " -c "SELECT s.shardid, \
  11. nodename, nodeport FROM pg_dist_shard s JOIN pg_dist_shard_placement p ON (s.shardid = p.shardid) \
  12. WHERE logicalrelid::regclass = '$TABLE_NAME'::regclass;" |
  13. xargs -n 3 -P $PARALLEL_FACTOR sh -c "psql -h \$1 -p \$2 -c \"ALTER TABLE $TABLE_NAME_\$0 RENAME TO $NEW_TABLE_NAME_backup_\$0\""
  14.  
  15. export PGOPTIONS="-c citus.enable_ddl_propagation=off"
  16. psql -c "ALTER TABLE $TABLE_NAME RENAME to $NEW_TABLE_NAME"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement