ERROR "fe_sendauth: no password supplied" when trying to use custom role

[minhdtb]

Hello I have a sample Citus cluster deployed on k8s by using Stackgres, I have done these steps

Everything seems work fine if I use the postgres role

but I get an error when I try to create a custom role

I have tried to use run_command_on_workers but no luck

please tell me what I did wrong?

[JelteF]

The first method of CREATE USER is correct (run_command_on_workers is not needed for this). The issue there sounds like Stackgres does not set up communication correctly between nodes for the newly created user. This seems like a Stackgres bug/missing feature so please report it there.

For reference, if Stackgres uses certificates internally they might benefit from using the all keyword in the pg_ident.conf file to automatically set up authentication correctly: https://www.postgresql.org/docs/16/auth-username-maps.html (It's a new PG16 feature that I contributed exactly for this reason).