Re: BUG #9518: temporary login failure - "missing pg_hba entry"

=E2=80=8BThis particular host is listed in pg_hba.conf by host name rather =
than by
IP address.  Is it possible this error is due to an intermittent DNS
failure?=E2=80=8B

___________________________________________________________________________=
_______
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com


<http://www.rrdonnelley.com/>
* <Mike.Blackwell@rrd.com>*


On Mon, Mar 10, 2014 at 10:06 AM, Mike Blackwell <mike.blackwell@rrd.com>wr=
ote:

> Hmm... Interesting thought.  The server is built with SSL, but there's
> nothing on the app side that's explicitly enabling SSL, nor is the user
> account in question set up for SSL.  That's on the TODO list at the momen=
t.
> :)
>
> So, looks like that's not it.  Thanks, though.  I'd missed that
> possibility.
>
>
> _________________________________________________________________________=
_________
> *Mike Blackwell | Technical Analyst, Distribution Services/Rollout
> Management | RR Donnelley*
> 1750 Wallace Ave | St Charles, IL 60174-3401
> Office: 630.313.7818
> Mike.Blackwell@rrd.com
> http://www.rrdonnelley.com
>
>
>  <http://www.rrdonnelley.com/>
> * <Mike.Blackwell@rrd.com>*
>
>
> On Mon, Mar 10, 2014 at 9:58 AM, Alvaro Herrera <alvherre@2ndquadrant.com=
>wrote:
>
>> mike.blackwell@rrd.com wrote:
>>
>> > 2014-03-09 19:53:18 CDT [30633]: [1-1] username@databasename10.17.x.y(=
53455)FATAL:  28000: no pg_hba.conf entry for host "10.17.x.y",
>> user "username", database "databasename", SSL off
>> > 2014-03-09 19:53:18 CDT [30633]: [2-1] username@databasename10.17.x.y(=
53455)LOCATION:  ClientAuthentication, auth.c:486
>>
>> > 2014-03-09 20:05:15 CDT [32505]: [1-1] username@databasename10.17.x.y(=
54134)LOG:  00000: duration: 13641.600 ms  execute dbdpg_p28498_2:
>> >
>> >                         select ...;
>> >
>> > 2014-03-09 20:05:15 CDT [32505]: [2-1] username@databasename10.17.x.y(=
54134)LOCATION:  exec_execute_message, postgres.c:1991
>> >
>> > The auth failure shows up seven times over a span of approximately six
>> > seconds, with the one above being the last of the sequence.
>>
>> So the connection that actually executes queries, is using SSL?  I'm
>> betting it's first trying one without SSL, failing, then trying with
>> SSL and succeeding.
>>
>> --
>> =C3=81lvaro Herrera                http://www.2ndQuadrant.com/
>> PostgreSQL Development, 24x7 Support, Training & Services
>>
>
>