def __insertConfigHistory(self, conn, dbId, msg):
     # now update change history
     sql = (
         'INSERT INTO gp_configuration_history (time, dbid, "desc") VALUES(\n'
         "now(),\n  " + self.__toSqlIntValue(dbId) + ",\n  " + self.__toSqlCharValue(msg) + "\n)"
     )
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)
Beispiel #2
0
 def __updateSegmentReplicationPort(self, conn, seg):
     # run an update
     sql = "UPDATE pg_catalog.gp_segment_configuration\n" + \
         "  SET\n" + \
         "  replication_port = " + self.__toSqlIntValue(seg.getSegmentReplicationPort()) + "\n" \
         "WHERE dbid = " + self.__toSqlIntValue(seg.getSegmentDbId())
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)
 def __updateSystemConfigFaultStrategy(self, conn, gpArray):
     """
     Update the fault strategy.
     """
     fs = gpArray.getFaultStrategy()
     sql = "UPDATE gp_fault_strategy\n SET fault_strategy = " + self.__toSqlCharValue(fs) + "\n"
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)
 def __insertConfigHistory(self, conn, dbId, msg):
     # now update change history
     sql = "INSERT INTO gp_configuration_history (time, dbid, \"desc\") VALUES(\n" \
                 "now(),\n  " + \
                 self.__toSqlIntValue(dbId) + ",\n  " + \
                 self.__toSqlCharValue(msg) + "\n)"
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)
Beispiel #5
0
 def __updateSegmentReplicationPort(self, conn, seg):
     # run an update
     sql = "UPDATE pg_catalog.gp_segment_configuration\n" + \
         "  SET\n" + \
         "  replication_port = " + self.__toSqlIntValue(seg.getSegmentReplicationPort()) + "\n" \
         "WHERE dbid = " + self.__toSqlIntValue(seg.getSegmentDbId())
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)
Beispiel #6
0
 def __updateSystemConfigFaultStrategy(self, conn, gpArray):
     """
     Update the fault strategy.
     """
     fs  = gpArray.getFaultStrategy()
     sql = "UPDATE gp_fault_strategy\n SET fault_strategy = " + self.__toSqlCharValue(fs) + "\n"
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)
Beispiel #7
0
 def __updateSegmentModeStatus(self, conn, seg):
     # run an update
     sql = "UPDATE pg_catalog.gp_segment_configuration\n" + \
         "  SET\n" + \
         "  mode = " + self.__toSqlCharValue(seg.getSegmentMode()) + ",\n" \
         "  status = " + self.__toSqlCharValue(seg.getSegmentStatus()) + "\n" \
         "WHERE dbid = " + self.__toSqlIntValue(seg.getSegmentDbId())
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)
 def __updateSegmentAddress(self, conn, seg):
     # run an update
     sql = "UPDATE pg_catalog.gp_segment_configuration\n" + \
         "  SET\n" + \
         "  hostname = " + self.__toSqlCharValue(seg.getHostName()) + ",\n" \
         "  address = " + self.__toSqlCharValue(seg.getAddress()) + "\n" \
         "WHERE dbid = " + self.__toSqlIntValue(seg.getRegistrationOrder())
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)
Beispiel #9
0
 def __updateSegmentModeStatus(self, conn, seg):
     # run an update
     sql = "UPDATE pg_catalog.gp_segment_configuration\n" + \
         "  SET\n" + \
         "  mode = " + self.__toSqlCharValue(seg.getSegmentMode()) + ",\n" \
         "  status = " + self.__toSqlCharValue(seg.getSegmentStatus()) + "\n" \
         "WHERE dbid = " + self.__toSqlIntValue(seg.getSegmentDbId())
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)
 def __updateSegmentAddress(self, conn, seg):
     # run an update
     sql = "UPDATE pg_catalog.gp_segment_configuration\n" + \
         "  SET\n" + \
         "  hostname = " + self.__toSqlCharValue(seg.getHostName()) + ",\n" \
         "  address = " + self.__toSqlCharValue(seg.getAddress()) + "\n" \
         "WHERE dbid = " + self.__toSqlIntValue(seg.getRegistrationOrder())
     logger.debug(sql)
     dbconn.executeUpdateOrInsert(conn, sql, 1)