From owner-freebsd-questions@FreeBSD.ORG  Tue Jun 14 19:24:16 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id E3EA816A41C
	for <freebsd-questions@freebsd.org>;
	Tue, 14 Jun 2005 19:24:16 +0000 (GMT)
	(envelope-from jonc@chen.org.nz)
Received: from chen.org.nz (chen.org.nz [210.54.19.51])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9821B43D5D
	for <freebsd-questions@freebsd.org>;
	Tue, 14 Jun 2005 19:24:16 +0000 (GMT)
	(envelope-from jonc@chen.org.nz)
Received: by chen.org.nz (Postfix, from userid 1000)
	id 721AB5641F; Wed, 15 Jun 2005 07:24:14 +1200 (NZST)
Date: Wed, 15 Jun 2005 07:24:14 +1200
From: Jonathan Chen <jonc@chen.org.nz>
To: "Joseph Koenig (jWeb)" <joe@jwebmedia.com>
Message-ID: <20050614192414.GB84823@osiris.chen.org.nz>
References: <BED45C51.1F46E%joe@jwebmedia.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <BED45C51.1F46E%joe@jwebmedia.com>
User-Agent: Mutt/1.4.2.1i
Cc: FreeBSD Mailing List <freebsd-questions@freebsd.org>
Subject: Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 14 Jun 2005 19:24:17 -0000

On Tue, Jun 14, 2005 at 10:05:05AM -0500, Joseph Koenig (jWeb) wrote:
> Hi,
> 
> I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on
> FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory
> to set the listen_address (and uncommented it) and have the port line
> uncommented and set to the default 5432. I then restarted the postmaster and
> tried to connect. I get:
> 
> could not connect to server: Connection refused
>         Is the server running on host "xx.xxx.xx.xxx" and accepting
>         TCP/IP connections on port 5432?
> 
> I can connect from localhost just fine.

You need to set listen_addresses, like it says in the comments:

	listen_addresses = '*'

This will allow Postgresql connections from all interfaces.
-- 
Jonathan Chen <jonc@chen.org.nz>
----------------------------------------------------------------------
                                             When all else fails, RTFM