Skip site navigation (1) Skip section navigation (2)

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

From: rfr <rfr(at)inter-land(dot)net>
To: "Gerrit P(dot) Haase" <gerrit(at)familiehaase(dot)de>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: pg_hba.conf is right ther, but connot connect
Date: 2003-10-17 12:29:52
Message-ID: 3F8FE0C0.9040407@inter-land.net (view raw or flat)
Thread:
Lists: pgsql-cygwin
Gerrit P. Haase wrote:

>Hallo pgsql-cygwin,
>
>I have tried what is stated in the FAQ, create an entry in pg_hba.conf
>and checking the status of postmaster with pg_ctl tells me:
>/usr/bin/postmaster '-D' '/usr/share/postgresql/data' '-i'
>
>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?
>
>
>Gerrit
>  
>
try to change tge IP-MASK to 255.255.255.255

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

Regards,

Fred


In response to

Responses

pgsql-cygwin by date

Next:From: Gerrit P. HaaseDate: 2003-10-17 12:35:22
Subject: Re: pg_hba.conf is right ther, but connot connect
Previous:From: Jason TishlerDate: 2003-10-17 12:28:14
Subject: Re: pg_hba.conf is right ther, but connot connect

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group