Re: Problem with pg_hba.conf - Mailing list pgsql-general

From Richard Huxton
Subject Re: Problem with pg_hba.conf
Date
Msg-id 422490FF.8010700@archonet.com
Whole thread Raw
In response to Problem with pg_hba.conf  (celerity12 <pgsql_backing@yahoo.com>)
List pgsql-general
Don't forget to cc the list.

celerity12 wrote:
> I turned on the connection logging:
>
> Server IP  is 192.168.160.213
>
> Client IP  is 192.168.160.212
>
> Its generating the entry for client in the log file
> but the IP of client is different( .212 not .213 ...
> .213 is server's IP)
>
> Getting this message:

> 2005-03-01 20:51:36 LOG:  connection received:
> host=192.168.160.213 port=3150
> 2005-03-01 20:51:36 FATAL:  no pg_hba.conf entry for
> host "192.168.160.213", user "postgres_db", database
> "template1"

It's not likely to be lying - you're getting the connection from
192.168.160.213 - now you need to find out why.

Have you got a firewall redirecting connections?

Are you running some sort of connection proxy?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Field count in a RECORD variable - plpgsql
Next
From: Wes
Date:
Subject: Re: Vacuum time degrading