How To See Primary To Mirror Mapping?

1.	How To See Primary To Mirror Mapping?
Answer» From database CATALOG FOLLOWING query list configuration on content ID, you can figure out primary and mirror for each content. GPDB=# select * from gp_configuration ORDER by content. Note: starting from GPDB 4.x, gp_segment_configuration table is used instead. gpdb=# select * from gp_segment_configuration order by dbid; From database catalog following query list configuration on content ID, you can figure out primary and mirror for each content. gpdb=# select * from gp_configuration order by content. Note: starting from GPDB 4.x, gp_segment_configuration table is used instead. gpdb=# select * from gp_segment_configuration order by dbid;

Answer»

From database CATALOG FOLLOWING query list configuration on content ID, you can figure out primary and mirror for each content.

GPDB=# select * from gp_configuration ORDER by content.

Note: starting from GPDB 4.x, gp_segment_configuration table is used instead.

gpdb=# select * from gp_segment_configuration order by dbid;

From database catalog following query list configuration on content ID, you can figure out primary and mirror for each content.

gpdb=# select * from gp_configuration order by content.

Note: starting from GPDB 4.x, gp_segment_configuration table is used instead.

gpdb=# select * from gp_segment_configuration order by dbid;

Discussion