From owner-freebsd-questions@FreeBSD.ORG  Tue Jun 14 20:14:32 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 140F116A41C
	for <freebsd-questions@freebsd.org>;
	Tue, 14 Jun 2005 20:14:32 +0000 (GMT)
	(envelope-from joe@jwebmedia.com)
Received: from smtp05.gnvlscdb.sys.nuvox.net (smtp.nuvox.net [64.89.70.9])
	by mx1.FreeBSD.org (Postfix) with ESMTP id CEB1043D48
	for <freebsd-questions@freebsd.org>;
	Tue, 14 Jun 2005 20:14:31 +0000 (GMT)
	(envelope-from joe@jwebmedia.com)
Received: from [192.168.1.107] (66.49.54.54.nw.nuvox.net [66.49.54.54])
	by smtp05.gnvlscdb.sys.nuvox.net (8.12.11/8.12.11) with ESMTP id
	j5EKF5wX028179
	for <freebsd-questions@freebsd.org>; Tue, 14 Jun 2005 16:15:06 -0400
User-Agent: Microsoft-Entourage/10.1.4.030702.0
Date: Tue, 14 Jun 2005 15:14:26 -0500
From: "Joseph Koenig (jWeb)" <joe@jwebmedia.com>
To: FreeBSD Mailing List <freebsd-questions@freebsd.org>
Message-ID: <BED4A4D2.1F4D0%joe@jwebmedia.com>
In-Reply-To: <20050614192414.GB84823@osiris.chen.org.nz>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
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 20:14:32 -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.

I have already tried setting the listen_addresses to * and the actual IP.
Neither of which has worked. I restarted the postmaster both times using the
script in /usr/local/etc/rc.d/, and by using pg_ctl. Even tried starting
postmaster with pg_ctl -i. Nothing seems to be working. I have
double-checked all of my pg_hba.conf settings, even though the error doesn't
indicate that is the problem at all.

Anyone else have any ideas at all? Thanks,

Joe Koenig
Production Manager
jWeb New Media Design
joe@jWebmedia.com
http://www.jwebmedia.com/
636.928.3162