Triggering create_distributed_table results in fe_sendauth: no password supplied
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?