Re: Failing tcp/ip connection

Thiemo,

> ################################################################
> Etwas ungewöhnliches ist passiert. Bitte Teilen Sie diesem Fehler
> mit: Exception: java.sql.SQLException: FATAL 1: No pg_hba.conf entry
> for host 192.168.0.249, user postgres, database template1

>
> My pg_hba.conf looks like this (at least the lines that aren't
> commented out). This file is located where my database directory is
> (/var/lib/pgsql). The third line is not necessairy as I understand. I
> put it to figure out if line 4 was bad.
> ################################################################
> local all crypt
> host all 127.0.0.1 255.255.255.255 crypt
> host all 192.168.0.249 255.255.255.255 crypt
> host all 192.168.0.0 255.255.255.0 crypt
> ################################################################
>
> I feel a bit stupid as I already had a running 7.2 on this machine,
> but I didn't want to run into sequence trouble anyhow. As I had about
> nothing on the 7.2 I just erased the databse directory.

1. Make sure that you are, in fact, accessing the pgsql/data/ directory
that you think you are.
2. Make sure that your startup script isn't accessing an alternate
pg_hba.conf directory.
3. Have you restarted Postmaster since you made the changes to
pg_hba.conf? Sometimes that's required.

-Josh Berkus