Re: BUG #11204: Log reason for authentication failure

tony.locke@wessexwater.co.uk writes:
> The following bug has been logged on the website:
> Bug reference:      11204
> Logged by:          Tony Locke
> Email address:      tony.locke@wessexwater.co.uk
> PostgreSQL version: 9.2.9
> Operating system:   Windows Server 2008
> Description:

> Hi, recently I couldn't work out why a user couldn't log in, and it turned
> out that their role had expired. In the log, postgres merely said that the
> log in had failed, but didn't give the reason. It would be really good if it
> said in the log that it failed because the role had expired.

Already done for 9.4 and later.

http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=64e43c59b817a78ddf70f2fd62de31a4add5d988

            regards, tom lane