How to clean up table in all segments created by an aborted transactions

posted Apr 28, 2017, 4:13 PM by Sachchida Ojha
1.  execute os level command in all the nodes using 
gpssh -f hostfile command. 

2. select 'PGOPTIONS=''-c gp_session_role=utility'' psql -p ' || port::text || ' -h ' || hostname || ' -c ' || '<your command here like drop table>'
from gp_segment_configuration 
where role = 'p' 
and preferred_role = role 
order by hostname, port;

This command should be used by Support only. Not for end user.
Comments