From owner-freebsd-questions@FreeBSD.ORG Thu Jan 1 11:34:44 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id D61061065672 for ; Thu, 1 Jan 2009 11:34:44 +0000 (UTC) (envelope-from stanb@panix.com) Received: from mail1.panix.com (mail1.panix.com [166.84.1.72]) by mx1.freebsd.org (Postfix) with ESMTP id 940078FC1F for ; Thu, 1 Jan 2009 11:34:44 +0000 (UTC) (envelope-from stanb@panix.com) Received: from mailbackend.panix.com (mailbackend.panix.com [166.84.1.89]) by mail1.panix.com (Postfix) with ESMTP id B900329407; Thu, 1 Jan 2009 06:34:43 -0500 (EST) Received: from teddy.fas.com (c-76-26-198-188.hsd1.sc.comcast.net [76.26.198.188]) by mailbackend.panix.com (Postfix) with ESMTP id 9395AF3CD; Thu, 1 Jan 2009 06:34:43 -0500 (EST) Received: from stan by teddy.fas.com with local (Exim 3.36 #1 (Debian)) id 1LILp5-00032y-00; Thu, 01 Jan 2009 06:34:43 -0500 Date: Thu, 1 Jan 2009 06:34:43 -0500 From: stan To: Andrew Falanga Message-ID: <20090101113443.GA11520@teddy.fas.com> Mail-Followup-To: Andrew Falanga , Free BSD Questions list References: <20090101004217.GA32222@teddy.fas.com> <340a29540812312022k5ab62972j9a11c0edf25b7448@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <340a29540812312022k5ab62972j9a11c0edf25b7448@mail.gmail.com> X-Editor: gVim X-Operating-System: Debian GNU/Linux X-Kernel-Version: 2.4.23 X-Uptime: 06:27:08 up 234 days, 12:49, 1 user, load average: 1.08, 0.45, 0.16 User-Agent: Mutt/1.5.4i Sender: Stan Brown Cc: Free BSD Questions list Subject: Re: postgresql network access problem 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: Thu, 01 Jan 2009 11:34:45 -0000 On Wed, Dec 31, 2008 at 09:22:22PM -0700, Andrew Falanga wrote: > On Wed, Dec 31, 2008 at 5:42 PM, stan wrote: > > > > I am having a bit of a problem enabling remote access to postgress on my > > 7.1 system. > > > > I have added to postgresql.conf > > > > listen_addresses = '*' > > > > and to pg_hba.conf > > > > host all all XXX.159.77.0/24 trust > > > > XX is a real number, and is the first octect of the network that this > > mahcine lives on > > > > Now, it appears that I alos need to add the -i, or -h flag to the > > invocation of postgress itslef, but I can't seem to get the rc.conf sysntax > > corrcet for that. What should this entry look like? > > > > Stan, > > I'm not aware of anything needed in /etc/rc.conf other than > > postgresql_enable="YES" > > I know the argument of which you speak. Lately, I've been using just > UNIX domain sockets for access to my databases but I do remember > having to use this argument, if memory serves it's the "-i" option, to > enable access on TCP (basically, it tells the daemon to open TCP > sockets when starting). I would, instead of looking for an rc.conf > entry, edit the script that starts the postgresql server in > /usr/local/etc/rc.d. From the following link, > http://www.freebsddiary.org/postgresql.php, if you're using a recent > server, perhaps 8.x, the file will be named "postgresql." If you're > using an older server, it will something like, "010.pgsql.sh." Find > the appropriate line that starts the server and modify the arguments > there. > Thanks. I did get it working. Here is the line that I used in rc.conf: postgresql_flags="-o '-i' -w -s -m fast" As a point of information, what was confusing me was, i had increased the number of connections in postgresql.conf. This had created a situation where I did not have enough kernel resources. This was loged in /var/log/messages. I crected this, but even then postgess would never start again, and no further messages werre put in /var/log/messages. I would up re init'g the database. -- One of the main causes of the fall of the roman empire was that, lacking zero, they had no way to indicate successful termination of their C programs.