timescaledb_information.data_nodes

Get information on data nodes in a multi-node cluster

Sunsetted v2.14.0 Since 2.0.0

Get information on data nodes. This function is specific to running in a multi-node setup.

Samples

Get metadata related to data nodes.

SELECT * FROM timescaledb_information.data_nodes;

 node_name    | owner      | options
--------------+------------+--------------------------------
 dn1         | postgres   | {host=localhost,port=15431,dbname=test}
 dn2         | postgres   | {host=localhost,port=15432,dbname=test}
(2 rows)

Returns

Name	Type	Description
node_name	TEXT	Data node name.
owner	REGCLASS	Oid of the user, who added the data node.
options	JSONB	Options used when creating the data node.