Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Triggering create_distributed_table results in fe_sendauth: no password supplied #7701

Open
sgojexcaliber opened this issue Oct 10, 2024 · 0 comments

Comments

@sgojexcaliber
Copy link

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 [email protected]: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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant