[pgpool-general: 4042] Re: MD5 authentication

[Pablo Sanchez]

[ Comments below, in-line ]

On 09/08/2015 11:27 AM, Thomas SIMON wrote:
>
>> On 09/08/2015 11:11 AM, Thomas SIMON wrote:
>
> Hi Pablo

Hey Thomas

> I have following lines :
>
> local   all             postgres                                trust
> local   all             all                                     trust
> host    all         all             127.0.0.1/32            trust

Assuming your PGPool set up is not on the same server as the DB
server, the above entries are fine.

> host    all         all         172.20.0.101/32         trust

The above isn't pgpool's IP eh?  172.20.0.101?

> I have this parameters enabled, and pool_hba.conf is loaded, because if
> I try to come from another IP, I have an negative answer from it
> ERROR:  no pool_hba.conf entry for host "1.2.3.4", user "toto", database
> "db1", SSL on

Have you confirmed the -a setting?

Cheers,
--
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph:    819.459.1926         Blog:  http://pablo-blog.blueoakdb.com
iNum:  883.5100.0990.1054