citusdata / citusdata/citus

Triggering create_distributed_table results in fe_sendauth: no password supplied

Open
#7,701 0 comments 0 reactions 0 assignees View on GitHub
Support
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

I am setting up Citus cluster having 1 Coord and 2 Workers.
I have created a user named citus on all servers using initdb.
I have properly set the coordinator node using citus_set_coordinator_host on all nodes.
I have set authentication using INSERT INTO pg_dist_authinfo
I have added workers to coordinator using citus_add_node
Checked the connectivity using citus_check_cluster_node_health

When trying to distribute a table when logged in as user citus , I was getting the above error. The full err msg

ERROR: connection to the remote node postgres@citus-cnpg-worker-2-rw.citus-cnpg.svc:5432 failed with the following error: fe_sendauth: no password supplied

SQL state: 08006

The Postgres user has been disabled on the nodes.

How to set the user for worker connections ?
Why is it using Postgres when I have setup the cluster using citus?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.