Re: pg_hba.conf is right ther, but connot connect

From: "Gerrit P(dot) Haase" <gerrit(at)familiehaase(dot)de>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: pg_hba.conf is right ther, but connot connect
Date: 2003-10-17 12:35:22
Message-ID: 1291390988365.20031017143522@familiehaase.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
--
=^..^=

In response to

Browse pgsql-cygwin by date

  From Date Subject
Next Message Gerrit P. Haase 2003-10-17 12:36:17 Re: pg_hba.conf is right ther, but connot connect
Previous Message rfr 2003-10-17 12:29:52 Re: pg_hba.conf is right ther, but connot connect