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

posted May 30, 2013, 10:08 AM 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