citus rebalance_table_shards() -> fe_sendauth: no password supplied

Solution 1:

The rebalancer connects to localhost and it seems you don't allow that in pg_hba.conf without a password. There's a few ways you could solve this:

1. add an entry for localhost to your .pgpass file, with the password for the localhost IP, both for ipv4 and ipv6 (127.0.0.1 and ::1)
2. add an entry to pg_hba.conf to allow passwordless logins from localhost, by using trust authentication
3. If you are on Citus 10.1 or higher, you can set citus.local_hostname to something that currently is in your pg_hba.conf file (like the node its public IP). It will then connect to the hostname/IP that you specify there instead of to localhost: https://docs.citusdata.com/en/v10.2/develop/api_guc.html#citus-local-hostname-text