Re: pg_hba.conf

Hi

>Would there be a line earlier in the file that matches and is preventing
>a connection?

At first, I think so too.
But if there is a line earlier in the file ,we get following error.

------------------------------------------------------------------------
psql: could not connect to server: Connection refused
Is the server running on host "192.168.23.132" and accepting
TCP/IP connections on port 1843?
------------------------------------------------------------------------

ex: my pg_hba.conf
------------------------------------------------------------------------
host all all 192.168.23.132 255.255.255.255 deny
host all all 192.168.23.132 255.255.255.255 trust
------------------------------------------------------------------------

The Jim's message say pg_hba.conf has no entory.

------------------------------------------------------------------------
FATAL: no pg_hba.conf entry for host "209.159.145.248", user "postgres",
database "arc"
------------------------------------------------------------------------

1)Is pg_hba.conf's location correct?
You can check to execute this command.

postgres=# show hba_file;
hba_file
-------------------------------
/home/p843/pgdata/pg_hba.conf
(1 row)

2)Did you reload pg_hba.conf?
If we change pg_hba.conf ,we must execute "pg_ctl reload"

3)pg_hba.conf may have a trash.
Can you recreate pg_hba.conf?
*Don't copy old pg_hba.conf.

Thank you.

> On 27/04/2010 11:42, jkunkel(at)laurcat(dot)com wrote:
>
>> I am putting up a new server on version 8.4.3. I copied pg_hba.conf
>> from a running 8.3.6 system, changing only the public IP address for the
>> local machine.
>>
>> I get the error:
>> FATAL: no pg_hba.conf entry for host "209.159.145.248", user "postgres",
>> database "arc"
>>
>> pg_hba.conf contains the line:
>> host all all 209.159.145.248 255.255.255.255
>> trust
>>
> Would there be a line earlier in the file that matches and is preventing
> a connection?
>
> Ray.
>
>

--
================================================
Kenichiro Tanaka
K.K.Ashisuto
http://www.ashisuto.co.jp/english/index.html
================================================