| -- Check how many WAL replication mirrors are up |
| SELECT count(*) FROM gp_segment_configuration where preferred_role='m' and status='u'; |
| count |
| ------- |
| 4 |
| (1 row) |
| |
| -- Check how many WAL replication mirrors are up and in-sync |
| SELECT count(*) FROM gp_segment_configuration where preferred_role='m' and mode='s'; |
| count |
| ------- |
| 4 |
| (1 row) |
| |
| -- Check pg_stat_replication view of master and primary segments |
| SELECT gp_segment_id, application_name, state, sync_state FROM gp_stat_replication; |
| gp_segment_id | application_name | state | sync_state |
| ---------------+------------------+-----------+------------ |
| 0 | gp_walreceiver | streaming | sync |
| 1 | gp_walreceiver | streaming | sync |
| 2 | gp_walreceiver | streaming | sync |
| -1 | gp_walreceiver | streaming | sync |
| (4 rows) |
| |
