From owner-freebsd-questions@FreeBSD.ORG Tue Jun 14 20:46:48 2005 Return-Path: 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 EC2F316A41C for ; Tue, 14 Jun 2005 20:46:48 +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 AE55E43D4C for ; Tue, 14 Jun 2005 20:46:48 +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 j5EKlDYb018578; Tue, 14 Jun 2005 16:47:14 -0400 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Tue, 14 Jun 2005 15:46:34 -0500 From: "Joseph Koenig (jWeb)" To: Message-ID: In-Reply-To: <200506141525.30185.algould@datawok.com> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Cc: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 14 Jun 2005 20:46:49 -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 I'm guessing that opening the port is part of what placing "postgresql_enable=YES" in the rc.conf file does, correct? If so, that's probably the problem as I have not rebooted since adding that. Is there a way to safely force that to run without rebooting? There is a hardware firewall in front of the server that I have ensured is allowing that port through. Thanks, Joe Koenig Production Manager jWeb New Media Design joe@jWebmedia.com http://www.jwebmedia.com/ 636.928.3162