tpch1000s=# SELECT * FROM gp_segment_configuration order by dbid; dbid | content | role | preferred_role | mode | status | port | hostname | address | datadir ------+---------+------+----------------+------+--------+------+----------+---------+-------------------------- 1 | -1 | p | p | n | u | 7456 | test-4 | gp10g_7 | /opt/gp/gpmaster/gpseg-1 2 | 0 | p | p | n | u | 6345 | test-1 | gp10g_4 | /opt/gp/gpdata/gpseg0 3 | 1 | p | p | n | u | 6346 | test-1 | gp10g_4 | /opt/gp/gpdata/gpseg1 4 | 2 | p | p | n | u | 6347 | test-1 | gp10g_4 | /opt/gp/gpdata/gpseg2