Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- export PGHOST=.....
- export PGUSER=citus
- export PGPASSWORD=....
- export PGSSLMODE=require
- export PGDATABASE=citus
- export TABLE_NAME=events
- export NEW_TABLE_NAME=events_backup
- export PARALLEL_FACTOR=4
- psql -tA -F" " -c "SELECT s.shardid, \
- nodename, nodeport FROM pg_dist_shard s JOIN pg_dist_shard_placement p ON (s.shardid = p.shardid) \
- WHERE logicalrelid::regclass = '$TABLE_NAME'::regclass;" |
- 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\""
- export PGOPTIONS="-c citus.enable_ddl_propagation=off"
- psql -c "ALTER TABLE $TABLE_NAME RENAME to $NEW_TABLE_NAME"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement