Tiger Cloud: Performance, Scale, Enterprise

Self-hosted products

MST

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

Warning

Multi-node support is sunsetted.

TimescaleDB v2.13 is the last release that includes multi-node support for Postgres versions 13, 14, and 15.

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)
NameTypeDescription
node_nameTEXTData node name.
ownerREGCLASSOid of the user, who added the data node.
optionsJSONBOptions used when creating the data node.

Keywords

Found an issue on this page?Report an issue or Edit this page in GitHub.