Unable to grant different authentication to different users
We have a need to setup different authentication types for different users, mainly a "trust" type for the dbadmin from the localhost, and "hash" for all other users. I have created a new authentication for "trust" type and granted it to the dbadmin, which works fine (dbadmin doesn't get prompted for a password when logging in from localhost). However, I am unable to login using another user (reader1) from localhost via vsql, I get the following error:
vsql: FATAL 2248: Authentication failed for username "reader1"
I am able to login using the same user from a remote host using a sql client (DBVisualizer). I would have expected the "trust" type to be assigned to only the user I assigned to, and so rest of the users' authentication type should remain the default, isn't it? Am I missing something?