Check segments that are currently resyncing

posted Oct 9, 2014, 2:41 PM by Sachchida Ojha
Run SQL

select * from gp_segment_configuration where mode = 'r';

This implies that the segment is in the process of getting resynched. If the state does not change from 'r' to 's' then check the pg_log from the primary and mirror of the impacted 
segments for errors.
Comments