We have migrated to new Google sites!
Post date: May 30, 2013 5:8:59 PM
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.