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@laurcat.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
================================================