attach_data_node()

Attach a data node to a hypertable. The data node should have been previously created using add_data_node.

When a distributed hypertable is created, by default it uses all available data nodes for the hypertable, but if a data node is added after a hypertable is created, the data node is not automatically 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.

Required arguments

Name Description
node_name Name of data node to attach
hypertable Name of distributed hypertable to attach node to

Optional arguments

Name Description
if_not_attached Prevents error if the data node is already attached to the hypertable. A notice is printed that the data node is attached. Defaults to FALSE.
repartition Change the partitioning configuration so that all the attached data nodes are used. Defaults to TRUE.

Returns

Column Description
hypertable_id Hypertable id of the modified hypertable
node_hypertable_id Hypertable id on the remote data node
node_name Name of the attached data node

Sample usage

Attach a data node dn3 to a distributed hypertable conditions previously created with create_distributed_hypertable.

2. SELECT * FROM attach_data_node('dn3','conditions');

4. hypertable_id | node_hypertable_id |  node_name

6. --------------+--------------------+-------------

8. 5 |                  3 | dn3

10. (1 row)
tip

You must add a data node to your distributed database first with add_data_node first before attaching it.