Reasons for detaching a data node include:

    • A data node should no longer be used by a hypertable and needs to be removed from all hypertables that use it
    • You want to have fewer data nodes for a distributed hypertable to partition across
    NameTypeDescription
    hypertableREGCLASSName of the distributed hypertable where the data node should be detached. If NULL, the data node is detached from all hypertables.
    BOOLEANPrevent error if the data node is not attached. Defaults to false.
    forceBOOLEANForce detach of the data node even if that means that the replication factor is reduced below what was set. Note that it is never allowed to reduce the replication factor below 1 since that would cause data loss.
    BOOLEANMake the number of space partitions equal to the new number of data nodes (if such partitioning exists). This ensures that the remaining data nodes are used evenly. Defaults to true.

    Errors

    Detaching a node is not permitted:

    • If it would result in under-replicated chunks for the distributed hypertable (without the force argument)
    tip

    Detaching a data node is under no circumstances possible if that would mean data loss for the hypertable. Nor is it possible to detach a data node, unless forced, if that would mean that the distributed hypertable would end up with under-replicated chunks.

    Detach data node from conditions: