From owner-freebsd-questions@FreeBSD.ORG Tue Jun 14 21:32:51 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 23DB716A41C for ; Tue, 14 Jun 2005 21:32:51 +0000 (GMT) (envelope-from joe@jwebmedia.com) Received: from smtp04.gnvlscdb.sys.nuvox.net (smtp.nuvox.net [64.89.70.9]) by mx1.FreeBSD.org (Postfix) with ESMTP id DA1C043D1D for ; Tue, 14 Jun 2005 21:32:50 +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 smtp04.gnvlscdb.sys.nuvox.net (8.12.11/8.12.11) with ESMTP id j5ELX4xg022292; Tue, 14 Jun 2005 17:33:05 -0400 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Tue, 14 Jun 2005 16:32:45 -0500 From: "Joseph Koenig (jWeb)" To: Ken Ebling , Message-ID: In-Reply-To: <955CFC64-9285-4A5C-ADF4-1F4A0C36FA50@idealinter.net> 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 (Solved) 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 21:32:51 -0000 > On Jun 14, 2005, at 4:46 PM, Joseph Koenig (jWeb) wrote: >> >> 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 >> >> _______________________________________________ >> freebsd-questions@freebsd.org mailing list >> http://lists.freebsd.org/mailman/listinfo/freebsd-questions >> To unsubscribe, send any mail to "freebsd-questions- >> unsubscribe@freebsd.org" >> >> !DSPAM:42af4251253444259514897! >> >> > > Hi Joe, > > You can confirm whether or not port 5432 is opened by typing "netstat > -na | grep 5432" on your database server. > > You should not have to reboot for the port to be opened. When > PostgreSQL starts, (either by starting it manually, or then the > machine boots) it will open the port. > > IIt definitely sounds like the firewall could be your problem. I'd > try connecting to the database server's port 5432 via telnet from an > outside location, so that your packets have to pass thru the firewall > in question. > > Thanks, > > Ken Ebling > Ideal Internet, Inc. > 561-963-4501 > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" Thanks to Ken and everyone who sent in recommendations - looks like it was an issue of a network admin who assured me the firewall was open when it really wasn't... Joe Koenig Production Manager jWeb New Media Design joe@jWebmedia.com http://www.jwebmedia.com/ 636.928.3162