After activating standby as master, you can add a standby to the current master.
Then you will have one master and one standby. Cheers Lei On Wed, Oct 31, 2018 at 5:51 PM <[email protected]> wrote: > 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 >
