Hi! I test with hawq HA, and find if kill master process, activate standby as master is ok, but there is no more standby node:
20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- HAWQ instance status summary 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:------------------------------------------------------ 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- Master instance = Active 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- No Standby master defined <==== 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- Total segment instance count from config file = 2 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:------------------------------------------------------ 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- Segment Status 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:------------------------------------------------------ 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- Total segments count from catalog = 2 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- Total segment valid (at master) = 2 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- Total segment failures (at master) = 0 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- Total number of postmaster.pid files missing = 0 20181031:17:44:05:1050788 hawq_state:test-1:gpadmin-[INFO]:-- Total number of postmaster.pid files found = 2 Does it mean HA only work for one time? Is there any way to set standby again after activate standby? Thanks
