Detach a data node from one hypertable or from all hypertables.
Reasons for detaching a data node include:
|TEXT||Name of data node to detach from the distributed hypertable|
|REGCLASS||Name of the distributed hypertable where the data node should be detached. If NULL, the data node will be detached from all hypertables.|
|BOOLEAN||Prevent error if the data node is not attached. Defaults to false.|
|BOOLEAN||Force detach of the data node even if that means that the replication factor is reduced below what was set. Note that it will never be allowed to reduce the replication factor below 1 since that would cause data loss.|
|BOOLEAN||Make 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.|
The number of hypertables the data node was detached from.
Detaching a node is not permitted:
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.
The only safe way to detach a data node is to first safely delete any data on it or replicate it to another data node.
Detach data node
SELECT detach_data_node('dn3', 'conditions');
Found an issue on this page?Report an issue!