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

Re: Database Server Remote connection failed

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
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:23:26
Message-ID: 46504BCE.3060705@kaltenbrunner.cc (view raw or flat)
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.conf
> enable remote tcp/ip connection:
> listen_addresses = '*'
> port = 5432
> max_connection = 100
>  
> 2. edit /usr/local/pgsql/data/pg_hba.conf
> add 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)

8.0.0-rc1 ???

>  
> 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?

well "no route to host" is a network level problem - either you client
is not connected (physically or logically) to that network at all - your
you have a firewall on either the client or the server that is blocking
your requests.


Stefan

In response to

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2007-05-20 13:24:28
Subject: Re: Database Server Remote connection failed
Previous:From: Devrim GÜNDÜZDate: 2007-05-20 12:21:15
Subject: Re: postgresql 8.2.4 install problem

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