Re: Problem with pg_hba.conf

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