X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DDF3C535DF for ; Wed, 27 Apr 2005 14:14:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22389-10 for ; Wed, 27 Apr 2005 17:14:02 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 1581353836 for ; Wed, 27 Apr 2005 14:13:25 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 27 Apr 2005 12:13:14 -0500 Subject: Re: Client Authentication problem From: Scott Marlowe To: Vaneet Sharma Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1114621994.13303.1310.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 27 Apr 2005 12:13:14 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.297 tagged_above=0 required=5 tests=AWL, HOT_NASTY X-Spam-Level: X-Archive-Number: 200504/381 X-Sequence-Number: 17394 On Wed, 2005-04-27 at 11:43, Vaneet Sharma wrote: > Hello, > > I am using postgreSQL 8.0.2 > > I configured the database, started postmaster. It is running well. I > can check and see it with ps anx command. > > I am running postgreSQL on centos 3.4 and Centos 4.0 machines > > Well, I created a database called test as well by command line on > secure CRT > > Now the problem is that: > When I try to connect to my server using pgAdminIII, it is giving me > the following error : > > "Error connecting to the server: could not connect to the server: No > route to host ( 0X00002751/10065). > Is the server running on host 212.xx.xxx.xxx and accepting TCP/IP > connections on port 5432? " > > > I have read pg_hba file and also included the IP entry of my machine > from which I am connecting > Entry Is below: > > host all all 192.168.50.122 255.255.255.0 > trust This sounds like a networking problem right now. I note that the IP you're trying to connect to has a 212.xxx.xxx.xxx while the host you're connecting from needs to be 192.168.xxx.xxx. Since 192.168 is generally not routed around a lot, I'm guessing you've got a dns / etc/hosts issue but can't really be sure. what does 'traceroute dbhostname' say?