From owner-freebsd-questions@FreeBSD.ORG Tue Jun 14 16:07: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 D4C0316A41C for ; Tue, 14 Jun 2005 16:07:48 +0000 (GMT) (envelope-from kalashnikovi@mail.ru) Received: from mx3.mail.ru (mx3.mail.ru [194.67.23.149]) by mx1.FreeBSD.org (Postfix) with ESMTP id 864BF43D1D for ; Tue, 14 Jun 2005 16:07:48 +0000 (GMT) (envelope-from kalashnikovi@mail.ru) Received: from [194.44.21.158] (port=17505 helo=n-ss) by mx3.mail.ru with asmtp id 1DiDx4-0001wG-00; Tue, 14 Jun 2005 20:07:46 +0400 From: Kalashnikov Ilya To: "Joseph Koenig (jWeb)" In-Reply-To: References: Date: Tue, 14 Jun 2005 19:10:00 +0300 Message-Id: <1118765400.64621.8.camel@n-ss> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1.1 FreeBSD GNOME Team Port Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 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 16:07:49 -0000 On Tue, 2005-06-14 at 10:05 -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. 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" > also check how database is started. example: pg_ctl start -D $PGDATA -o -i Options -i listen tcp connection. -- Kalashnikov Ilya