From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
---|---|
To: | 王峰 <wangfengjs(at)163(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Database Server Remote connection failed |
Date: | 2007-05-20 13:24:28 |
Message-ID: | 46504C0C.50608@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
王峰 wrote:
> Hi,I can't establish a connection to PostgreSQL(version postgresql-8.2.4) Server. I'am sure what i config is right. Following are 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 client that will connect to the server to pg_hba.conf for example:PC_Server IP: 192.168.1.98 Running PostgreSQL Server. Linux OS.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 connection to 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, or whatever 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jason | 2007-05-20 13:30:53 | BUG #3294: PostgreSQL Setting permissions for folders during installation then Crashing |
Previous Message | Stefan Kaltenbrunner | 2007-05-20 13:23:26 | Re: Database Server Remote connection failed |