Re: BUG #11204: Log reason for authentication failure - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #11204: Log reason for authentication failure
Date
Msg-id 18413.1408371547@sss.pgh.pa.us
Whole thread Raw
In response to BUG #11204: Log reason for authentication failure  (tony.locke@wessexwater.co.uk)
Responses Re: BUG #11204: Log reason for authentication failure
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: BUG #11178: JSONB : The NOT operator applies to the <@ operator, even after casting to ::bool
Next
From: cbarham@pobox.com
Date:
Subject: BUG #11205: Documentation - loading the JDBC driver