Path: g2news2.google.com!news4.google.com!feeder.news-service.com!newsfeed.straub-nv.de!weretis.net!feeder4.news.weretis.net!news.hub.org!postgresql.org!pgsql-general-owner+M173789
From: adrian.kla...@gmail.com (Adrian Klaver)
Newsgroups: pgsql.general
Subject: Re: [GENERAL] How to add hosts to pg_hba.conf and postgresql.conf?
Date: Tue, 15 Mar 2011 10:28:14 -0700
Organization: Hub.Org Networking Services
Lines: 34
Sender: n...@news.hub.org
Message-ID: <4D7FA1AE.2020501@gmail.com>
References: <1300204234908-3708421.post@n5.nabble.com> <201103150927.05193.adrian.klaver@gmail.com> <1300206966925-3709528.post@n5.nabble.com>
NNTP-Posting-Host: news.hub.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.hub.org 1300210140 89060 200.46.204.72 (15 Mar 2011 17:29:00 GMT)
X-Complaints-To: usenet@news.hub.org
NNTP-Posting-Date: Tue, 15 Mar 2011 17:29:00 +0000 (UTC)
X-Received: from mx2.hub.org (mx2.hub.org [200.46.204.254])
	by news.hub.org (8.14.4/8.14.4) with ESMTP id p2FHT0I4088972
	for <pgsql-gene...@news.hub.org>; Tue, 15 Mar 2011 14:29:00 -0300 (ADT)
	(envelope-from pgsql-general-owner+M173...@postgresql.org)
X-Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
	by mx2.hub.org (Postfix) with ESMTP id F08F83EAD223;
	Tue, 15 Mar 2011 14:28:59 -0300 (ADT)
X-Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 7CDDA1337BE9
	for <pgsql-general-postgresql....@mail.postgresql.org>; Tue, 15 Mar 2011 14:28:25 -0300 (ADT)
X-Received: from mail.postgresql.org ([200.46.204.86])
 by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024)
 with ESMTP id 72215-10
 for <pgsql-general-postgresql....@mail.postgresql.org>;
 Tue, 15 Mar 2011 17:28:18 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174])
	by mail.postgresql.org (Postfix) with ESMTP id 1346E1337BC8
	for <pgsql-gene...@postgresql.org>; Tue, 15 Mar 2011 14:28:17 -0300 (ADT)
X-Received: by pvg12 with SMTP id 12so132163pvg.19
        for <pgsql-gene...@postgresql.org>; Tue, 15 Mar 2011 10:28:17 -0700 (PDT)
X-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:message-id:date:from:user-agent:mime-version:to
         :cc:subject:references:in-reply-to:content-type
         :content-transfer-encoding;
        bh=evatOVXvmM8rxjJoa7dVEtb/YUS6E6tu5TtXi9Qlp8M=;
        b=v58+0AjshBwB7SECLhgTRHwG7H+zuDX37Kqt24dhJXTJ5KT2aZs2rS/acZvSoJxa9s
         d5gdWHWfFe+gufrQWnKZv35PmBNZ+JBZwN0FRAmFK2YSB6gkDjAergu5wLpQFUTsVlUI
         1GebhmMp9AFcwh79RISauWZ6pnc65nwHEiJ+c=
X-DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:cc:subject
         :references:in-reply-to:content-type:content-transfer-encoding;
        b=RV2Ivc9Qn8u4/A25i3HWMTnGwNmqu3zIb7TeNqjoCkMB+UDIYDs3itS+0NsO/ng/4n
         5RgI5gIJpeSSVve/KwUnly/wRy8S60OyC3ifcs5tcjjl4cYxMCCcPyAUwhuPAvnnXRpL
         GixG4fP5X5EOSjnPPyHuoM3encCQCK6qdp4t8=
X-Received: by 10.143.46.3 with SMTP id y3mr9582600wfj.331.1300210097290;
        Tue, 15 Mar 2011 10:28:17 -0700 (PDT)
X-Received: from [192.168.0.107] (c-24-17-179-185.hsd1.wa.comcast.net [24.17.179.185])
        by mx.google.com with ESMTPS id p40sm17602wfc.17.2011.03.15.10.28.15
        (version=SSLv3 cipher=OTHER);
        Tue, 15 Mar 2011 10:28:16 -0700 (PDT)
X-User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
X-To: general_lee <tim_stockf...@hotmail.com>
X-CC: pgsql-gene...@postgresql.org
X-In-Reply-To: <1300206966925-3709528.p...@n5.nabble.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
 FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: 
X-Mailing-List: pgsql-general
X-List-Archive: <http://archives.postgresql.org/pgsql-general>
X-List-Help: <mailto:majord...@postgresql.org?body=help>
X-List-ID: <pgsql-general.postgresql.org>
X-List-Owner: <mailto:pgsql-general-ow...@postgresql.org>
X-List-Post: <mailto:pgsql-gene...@postgresql.org>
X-List-Subscribe: <mailto:majord...@postgresql.org?body=sub%20pgsql-general>
X-List-Unsubscribe: <mailto:majord...@postgresql.org?body=unsub%20pgsql-general>
X-Precedence: bulk

On 03/15/2011 09:36 AM, general_lee wrote:
> Both the below were ran on the Postgres Server.
>
>
> $ telnet  5432
> Trying ...
> telnet: Unable to connect to remote host: Connection refused
>
>
>
> $ psql -h  -U post_owner -d post_db
> psql: could not connect to server: Connection refused
>          Is the server running on host "" and accepting
>          TCP/IP connections on port 5432?

With the above connection string you are not actually connecting to a 
host. From the error message 'Is the server running on host ""...'

>
>
> Thanks,
>



-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general