Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 039381F02EF3 for ; Thu, 26 Apr 2012 12:37:17 -0300 (ADT) Received: from 74-93-229-125-colorado.hfc.comcastbusiness.net ([74.93.229.125] helo=mail.consistentstate.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SNQku-0006x3-KQ for pgsql-admin@postgresql.org; Thu, 26 Apr 2012 15:37:17 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.consistentstate.com (Postfix) with ESMTP id 870E630FE9B; Thu, 26 Apr 2012 09:37:02 -0600 (MDT) X-Virus-Scanned: amavisd-new at consistentstate.com Received: from mail.consistentstate.com ([127.0.0.1]) by localhost (mail.consistentstate.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id M-APKjWMFPoS; Thu, 26 Apr 2012 09:36:58 -0600 (MDT) Received: from Issac.consistentstate.com (c-67-165-192-103.hsd1.co.comcast.net [67.165.192.103]) by mail.consistentstate.com (Postfix) with ESMTPSA id B0A133093F9; Thu, 26 Apr 2012 09:36:57 -0600 (MDT) Message-ID: <4F996B98.3040508@consistentstate.com> Date: Thu, 26 Apr 2012 09:36:56 -0600 From: Kevin Kempter User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:11.0) Gecko/20120329 Thunderbird/11.0.1 MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: psql: could not connect to server: No route to host References: <4F98D19D.6060303@consistentstate.com> <23291.1335415839@sss.pgh.pa.us> In-Reply-To: <23291.1335415839@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.9 (/) X-Archive-Number: 201204/142 X-Sequence-Number: 39478 On 04/25/2012 10:50 PM, Tom Lane wrote: > Kevin Kempter writes: >> I can scp files between the servers > Really? > >> $ psql -h 192.168.1.125 >> psql: could not connect to server: No route to host > Because that is not a Postgres problem, that is a network connectivity > problem. I'd bet that there's something wrong with the VM > configuration, such that the VM host isn't connecting 192.168.1.* in one > VM to 192.168.1.* in the other. > > regards, tom lane Scientific Linux turns on the firewall by default. It lets me scp via username & passwd but wouldn't allow the port 5432 tcp connection till I disabled it. I like Scientific because it seems that they are a large team and as a project seem to have better long term viability than other RH based projects but a couple of their defaults drive me nuts. Like this one, and the default install of yum-autoupdate