def cleanup(context): utils.stop_database_if_started(context) subprocess.check_call(['gpstart', '-am']) _run_sql( """ SET allow_system_table_mods='true'; UPDATE gp_segment_configuration SET hostname = coordinator.hostname, address = coordinator.address FROM ( SELECT hostname, address FROM gp_segment_configuration WHERE content = -1 and role = 'p' ) coordinator WHERE content = -1 AND role = 'm' """, {'gp_role': 'utility'}) subprocess.check_call(['gpstop', '-am'])
def cleanup(context): """ Reverses the above SQL by starting up in coordinator-only utility mode. Since the standby host is incorrect, a regular gpstart call won't work. """ utils.stop_database_if_started(context) subprocess.check_call(['gpstart', '-am']) _run_sql(""" SET allow_system_table_mods='true'; UPDATE gp_segment_configuration SET hostname = coordinator.hostname, address = coordinator.address FROM ( SELECT hostname, address FROM gp_segment_configuration WHERE content = -1 and role = 'p' ) coordinator WHERE content = -1 AND role = 'm' """, {'gp_role': 'utility'}) subprocess.check_call(['gpstop', '-am'])
def cleanup(context): """ Reverses the above SQL by starting up in master-only utility mode. Since the standby host is incorrect, a regular gpstart call won't work. """ utils.stop_database_if_started(context) subprocess.check_call(['gpstart', '-am']) _run_sql(""" UPDATE gp_segment_configuration SET hostname = master.hostname, address = master.address FROM ( SELECT hostname, address FROM gp_segment_configuration WHERE content = -1 and role = 'p' ) master WHERE content = -1 AND role = 'm' """, opts=opts) subprocess.check_call(['gpstop', '-am'])