citus add node --> "fe_sendauth: no password supplied" error

Question

I am trying to setup multi node schema based sharding for postgresql database using citus extension.

I have two azure virtual machines , one is working as worker node('20.40.43.246') and other as coordinator ('20.198.17.232')

I am following this documention https://docs.citusdata.com/en/stable/installation/multi_node_debian.html#steps-to-be-executed-on-all-nodes

On worker node database is set up and it is running fine.

on coordiator node when i run sudo -i -u postgres psql -c "SELECT * from citus_add_node('20.40.43.246', 5432);" I am getting below error.

ERROR:  connection to the remote node 20.40.43.246:5432 failed with the following error: fe_sendauth: no password supplied

What configuration do i need to change in pb_hba.conf on worker node?

jjanes · Accepted Answer · 2024-03-20 16:59:43Z

1

You would need to add 20.40.43.246 to the pg_hba instead of the 10.* which that link shows. But I would worry that maybe the IP address will get assigned to someone else someday, who would then have access to your system. Since Citus is owned by Microsoft now, its seems like you might be able to find some Azure-specific instructions.

Also, your hba must have some lines besides the one shown at that link, otherwise you would not be getting that error message.

answered Mar 20, 2024 at 16:59

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

citus add node --> "fe_sendauth: no password supplied" error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related