If you have multiple instances of PostgreSQL running TimescaleDB 2.0 or greater, you can set them up to act as a TimescaleDB multi-node environment.
To start, you'll need to have the following:
postgres) on all nodes
All nodes begin as standalone TimescaleDB instances, i.e., hosts with a running PostgreSQL server and a loaded TimescaleDB extension. This is assumed for "access node" and "data node" in the instructions. More detail on the architecture can be found in the Core Concepts section.
TimescaleDB multi-node can be created as part of a self-managed deployment or as a managed cloud deployment.
To set up a self-managed cluster, including configuring the nodes for secure communication and creating users and roles across servers, follow the instructions in this section.
If you would like to give multi-node a try without the management overhead, you can setup and explore a multi-node cluster in Timescale Forge, our fully managed database service. Sign-up for your free, 30-day trial and get started today!