Re: Database Server Remote connection failed

王峰 wrote:
> Hi,I can't establish a connection to PostgreSQL(version postgresql-8.2.4) Server. I'am sure what i config is right.
Followingare what i do to enable remote connection: 1. edit/usr/local/pgsql/data/postgresql.confenable remote tcp/ip
connection:listen_addresses= '*'port = 5432max_connection = 100 2. edit/usr/local/pgsql/data/pg_hba.confadd remote
clientthat will connect to the server to pg_hba.conf for example:PC_Server IP: 192.168.1.98 Running PostgreSQL Server.
LinuxOS.PC_Client IP: 192.168.1.25 Will connect to the PC_Server. Windows XP OS so, i add one line to pg_hba.conf :host
  all    all    192.168.1.25/32    trust---------------------------------------------------But when i established a
connectionto the PC_Server on the PC_Client(C:\Program Files\PostgreSQL\8.0.0-rc1\bin>psql -h 192.168.1.98 -U postgres
postgres)the system give me one message: 
> psql: could not connect to server: No route to host (0x00002751/10065)
>         Is the server running on host "192.168.1.98" and accepting
>         TCP/IP connections on port 5432?---------------------------------------------------------Please tell me why,
orwhatever i made mistake.Thanks!    

"No route to host" sounds like a network configuration problem. Make
sure you can reach the server from the client with "ping 192.168.1.98".

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com