Warning

Multi-node support is deprecated.

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

Tables and values referenced by a distributed hypertable must be present on the access node and all data nodes. To create a foreign key from a distributed hypertable, use distributed_exec to first create the referenced table on all nodes.

  1. Create the referenced table on the access node.
  2. Use distributed_exec to create the same table on all data nodes and update it with the correct data.
  3. Create a foreign key from your distributed hypertable to your referenced table.

Keywords

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