Attach a data node to a hypertable. The data node should have been
previously created using
When a distributed hypertable is created it will by default use all available data nodes for the hypertable, but if a data node is added after a hypertable is created, the data node will not automatically be used by existing distributed hypertables.
If you want a hypertable to use a data node that was created later, you must attach the data node to the hypertable using this function.
|Name of data node to attach|
|Name of distributed hypertable to attach node to|
|Prevents error if the data node is already attached to the hypertable. A notice will be printed that the data node is attached. Defaults to |
|Change the partitioning configuration so that all the attached data nodes are used. Defaults to |
|Hypertable id of the modified hypertable|
|Hypertable id on the remote data node|
|Name of the attached data node|
Attach a data node
dn3 to a distributed hypertable
previously created with
SELECT * FROM attach_data_node('dn3','conditions'); hypertable_id | node_hypertable_id | node_name --------------+--------------------+------------- 5 | 3 | dn3 (1 row)
add_data_nodefirst before attaching it.
Found an issue on this page?Report an issue!