Information
If users with database accounts that have the ability to login do not have a password set then anyone can masquerade as these users.
All accounts that can login to the database should challenge the user for an account password.
Solution
Set a valid password for any database user identified above.
postgres=# \\password user1
This shows setting the password for user1 . You can user ALTER ROLE, but note that the passwords will be emitted to the PostgreSQL logs.