Hello Raghavendra, I think probably psql is a problem here. WIthout -W (force password before connect) option psql has no way knowing if this user needs a password to connect to the given database. So, psql first attempts a connection to the database without a password (if -W is not specified), which fails since server responds with "password needed" kind of message back to psql (this is because we have set 'pam' as the authentication method). This makes psql know that a password is needed for this user/database combination and it prompts for the password and subsequently connects successfully if correct password is specified. But this first unsuccessful attempt is indeed logged by the server as authentication failure just as what you see. So, this logged failure is just the kind of dummy connection attempt (indeed withoutn password) made by the psql. However, if you specify -W option, psql won't connect before it accepts password. You can try this (and see that no authentication failure is logged) I think log entries just mean the authentication has failed with PAM-specific error message. -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
