From owner-freebsd-questions@FreeBSD.ORG  Tue Jun 14 15:05:11 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 40AB416A41C
	for <freebsd-questions@freebsd.org>;
	Tue, 14 Jun 2005 15:05:11 +0000 (GMT)
	(envelope-from joe@jwebmedia.com)
Received: from smtp03.gnvlscdb.sys.nuvox.net (smtp.nuvox.net [64.89.70.9])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0AE1B43D1D
	for <freebsd-questions@freebsd.org>;
	Tue, 14 Jun 2005 15:05:10 +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 smtp03.gnvlscdb.sys.nuvox.net (8.12.11/8.12.11) with ESMTP id
	j5EF5Kag009738
	for <freebsd-questions@freebsd.org>; Tue, 14 Jun 2005 11:05:20 -0400
User-Agent: Microsoft-Entourage/10.1.4.030702.0
Date: Tue, 14 Jun 2005 10:05:05 -0500
From: "Joseph Koenig (jWeb)" <joe@jwebmedia.com>
To: FreeBSD Mailing List <freebsd-questions@freebsd.org>
Message-ID: <BED45C51.1F46E%joe@jwebmedia.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
Subject: 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 15:05:11 -0000

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. Is there anything that needs to be
set in /etc/inetd.conf or /etc/hosts.allow? I have postgresql_enable="YES"
in my /etc/rc.conf file, but have not rebooted since I added that. If that's
the problem, is there a good way to load that value without rebooting? Is it
just an environmental variable? Thanks,

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