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. |
Greenplum DBA FAQ >