From owner-freebsd-questions@FreeBSD.ORG  Tue Jun 14 20:24:46 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 CD93216A41C
	for <freebsd-questions@freebsd.org>;
	Tue, 14 Jun 2005 20:24:46 +0000 (GMT)
	(envelope-from algould@datawok.com)
Received: from smtpauth09.mail.atl.earthlink.net
	(smtpauth09.mail.atl.earthlink.net [209.86.89.69])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9F95943D1D
	for <freebsd-questions@freebsd.org>;
	Tue, 14 Jun 2005 20:24:46 +0000 (GMT)
	(envelope-from algould@datawok.com)
Received: from [206.255.31.21] (helo=yoda.datawok.com)
	by smtpauth09.mail.atl.earthlink.net with asmtp (TLSv1:RC4-MD5:128)
	(Exim 4.34) id 1DiHxl-0006kR-Ul; Tue, 14 Jun 2005 16:24:46 -0400
From: "Andrew L. Gould" <algould@datawok.com>
To: freebsd-questions@freebsd.org
Date: Tue, 14 Jun 2005 15:25:30 -0500
User-Agent: KMail/1.6.2
References: <BED4A4D2.1F4D0%joe@jwebmedia.com>
In-Reply-To: <BED4A4D2.1F4D0%joe@jwebmedia.com>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <200506141525.30185.algould@datawok.com>
X-ELNK-Trace: ee791d459e3d6817d780f4a490ca69563f9fea00a6dd62bc4cfbd06cf44f2618f097b854c7f10218350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c
X-Originating-IP: 206.255.31.21
Cc: "Joseph Koenig \(jWeb\)" <joe@jwebmedia.com>
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:24:46 -0000

On Tuesday 14 June 2005 03:14 pm, Joseph Koenig (jWeb) wrote:
> > 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


Have you checked the firewall settings on both computers to ensure that 
port 5432 is open?

Andrew Gould