Re: pg_hba.conf is right ther, but connot connect - Mailing list pgsql-cygwin

From Gerrit P. Haase
Subject Re: pg_hba.conf is right ther, but connot connect
Date
Msg-id 1291390988365.20031017143522@familiehaase.de
Whole thread Raw
In response to Re: pg_hba.conf is right ther, but connot connect  (rfr <rfr@inter-land.net>)
List pgsql-cygwin
Hello,

>>pg_hba.conf:
>># TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
>>
>>local   all         all                                             trust
>>host    all         all         127.0.0.1         255.255.255.255   trust
>>host    all         all         192.168.5.3       255.255.255.0     trust

>>When I try to connect from remote:
>>$ psql -h 192.168.5.5 -d dbmail -U dbmail
>>psql: FATAL:  No pg_hba.conf entry for host 192.168.5.3, user dbmail, database dbmail

>>What else may I check or try?

> try to change tge IP-MASK to 255.255.255.255

> But think twice before giving a trust relationship to that kind of entry ...

I'm behind a firawall, no problem with this.
It works now with this IP_MASK after I shutdown the database completely,
maybe pg_ctl reload doesn't work correct?

Thanks for the help,
Gerrit
--
=^..^=


pgsql-cygwin by date:

Previous
From: rfr
Date:
Subject: Re: pg_hba.conf is right ther, but connot connect
Next
From: "Gerrit P. Haase"
Date:
Subject: Re: pg_hba.conf is right ther, but connot connect