From owner-freebsd-questions@FreeBSD.ORG Tue Jun 14 15:22: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 1891016A41C for ; Tue, 14 Jun 2005 15:22:48 +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 A73AD43D48 for ; Tue, 14 Jun 2005 15:22:47 +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 j5EFN3dN022969; Tue, 14 Jun 2005 11:23:03 -0400 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Tue, 14 Jun 2005 10:22:44 -0500 From: "Joseph Koenig (jWeb)" To: Kalashnikov Ilya Message-ID: In-Reply-To: <1118762272.64621.4.camel@n-ss> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Cc: FreeBSD Mailing List 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 15:22:48 -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 >> >> _______________________________________________ >> 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" >> > > -- see pg_hba.conf in $PGDATA directory. :) > > _______________________________________________ > 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" I guess I should have specified that I have already added the appropriate entries into pg_hba.conf. I thought that the error message would be enough to indicate it was not an authentication problem, as that generates an error stating there is not an entry in pg_hba for that host. Thanks, Joe Koenig Production Manager jWeb New Media Design joe@jWebmedia.com http://www.jwebmedia.com/ 636.928.3162