Re: Failing tcp/ip connection - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Failing tcp/ip connection
Date
Msg-id web-1236988@davinci.ethosmedia.com
Whole thread Raw
In response to Failing tcp/ip connection  (thiemo <thiemo@gmx.ch>)
Responses Re: Failing tcp/ip connection  (thiemo <thiemo@gmx.ch>)
List pgsql-novice
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



pgsql-novice by date:

Previous
From: thiemo
Date:
Subject: Failing tcp/ip connection
Next
From: "Juliet May"
Date:
Subject: less not found