From owner-freebsd-questions@FreeBSD.ORG Tue Jun 14 20:55:27 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 F330E16A41C for ; Tue, 14 Jun 2005 20:55:26 +0000 (GMT) (envelope-from ken@idealinter.net) Received: from mail.idealinter.net (mail.idealinter.net [72.242.8.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id C2B6043D1F for ; Tue, 14 Jun 2005 20:55:26 +0000 (GMT) (envelope-from ken@idealinter.net) Received: from [192.168.0.2] (unknown [72.242.8.254]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by mail.idealinter.net (Postfix) with ESMTP id 388F410E42C for ; Tue, 14 Jun 2005 16:55:26 -0400 (EDT) Mime-Version: 1.0 (Apple Message framework v730) In-Reply-To: References: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <955CFC64-9285-4A5C-ADF4-1F4A0C36FA50@idealinter.net> Content-Transfer-Encoding: 7bit From: Ken Ebling Date: Tue, 14 Jun 2005 16:55:25 -0400 To: freebsd-questions@freebsd.org X-Mailer: Apple Mail (2.730) 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:55:27 -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