Timescale DB Create distributed hypertable

Question

I want to create a PoC of a distributed hypertable, using TimescaleDB and docker compose.

I've set up a docker compose with two instances and created the respective table in both instances.

Let's say instance A is the access node (main node) Before executing the query SELECT create_distributed_hypertable('sensor_data', 'time', 'sensor_id');, I added the other data node successfully by running: SELECT add_data_node('australia-node', host => 'au-db', password => 'XXXXX', database => 'XXXXX');

Also, by querying SELECT * FROM timescaledb_information.data_nodes;, the australia-node is the only entry in this view, meaning that it is recgonized by the access node

When I try to run SELECT create_distributed_hypertable('sensor_data', 'time', 'sensor_id');, I receive the folllowing error:

SQL Error [08001]: ERROR: could not connect to "australia-node" Detail: fe_sendauth: no password supplied

Note: I execute all the queries, using DBeaver SQL editor

kittur_riyaz · Accepted Answer · 2023-05-12 12:19:47Z

1

Once your instances are up and running, you need to configure authentication so that data nodes accept connections from access node. This is what we refer as Multi-node authentication.

Since it is a PoC, go for Trust authentication which trusts all incoming connections and then create distributed hypertable

Reference: https://docs.timescale.com/self-hosted/latest/multinode-timescaledb/multinode-auth/

answered May 12, 2023 at 12:19

kittur_riyaz

1725 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

J2R Over a year ago

This was very helpful. Indeed this partially resolves my issue. In particular, I am able to create the distributed hypertable by following the steps in the link you provided. Thanks for the answer!!!

Collectives™ on Stack Overflow

Timescale DB Create distributed hypertable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related