On 11 Aug 2015 6:30 PM, Martín Marqués wrote:
>>
>> local samerole all md5
>> host samerole all 127.0.0.200 255.255.255.255 pam
>> pamservice=postgresql_cpses
>> host samerole all 127.0.0.1 255.255.255.255 md5
>> local all postgres md5
>> host all postgres 127.0.0.1 255.255.255.255 md5
>>
>> So connections to 127.0.0.200 are handled by pam, connections to
>> 127.0.0.1 are handled by md5.
>
> No! This means that connections that come from 127.0.0.200 are handled
> by pam, not connection *to*. Same for 127.0.0.1 (which in this case
> means nothing).
Ah … thank you!
This may indeed point to our fix … though, FWIW, it still seems curious
that the same configuration file worked as we expected in 8.4 but
changed in 9.x.
I’ll take this to my coworkers and see what comes …
-FG