Triggering create_distributed_table results in fe_sendauth: no password supplied
- 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
Assessment
This issue has not been assessed yet.