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@xxxxxxxxxxx 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
================================================
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
