Skip site navigation (1) Skip section navigation (2)

Database Server Remote connection failed

From: 王峰 <wangfengjs(at)163(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Database Server Remote connection failed
Date: 2007-05-20 08:42:15
Message-ID: 29313992.300611179650535278.JavaMail.coremail@bj163app43.163.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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!   

Responses

pgsql-bugs by date

Next:From: Devrim GÜNDÜZDate: 2007-05-20 12:21:15
Subject: Re: postgresql 8.2.4 install problem
Previous:From: farooq hasnyDate: 2007-05-20 06:50:30
Subject: BUG #3293: installation failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group