citus icon indicating copy to clipboard operation
citus copied to clipboard

Triggering create_distributed_table results in fe_sendauth: no password supplied

Open sgojexcaliber opened this issue 1 year ago • 0 comments

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?

sgojexcaliber avatar Oct 10 '24 12:10 sgojexcaliber