We have users for out postgres database and none have passwords... Do not know the history behind it.
When I try to use clients to connect to these databases, for instance, pgadmin III, the connection always fails due to the lack of password.
How does one overcome this? I do not want to create username with passwords just to get around this. Sometimes that is not an option.