From owner-freebsd-questions@FreeBSD.ORG Thu Jan 1 04:22:22 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 DDD3E106564A for ; Thu, 1 Jan 2009 04:22:22 +0000 (UTC) (envelope-from af300wsm@gmail.com) Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.235]) by mx1.freebsd.org (Postfix) with ESMTP id AFC9B8FC1C for ; Thu, 1 Jan 2009 04:22:22 +0000 (UTC) (envelope-from af300wsm@gmail.com) Received: by rv-out-0506.google.com with SMTP id f9so5495564rvb.4 for ; Wed, 31 Dec 2008 20:22:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=nV+SxjITmI0S/IIh1jr3gViU7TmkF3s0O0NhclEVVgw=; b=TnSxCXp+nuCkXejRznJVwL2mGWDLw21YriesUU7B80mJKZaSIf/H9K5zbDYAZHkNtE ME70k23/VCfQGdMLMkZWmOxDff4q6DYuEnh0eU5qmcbnd8xS5IhPHRvsT0F3t6WFhY8N RzzCV+MipxRf9D+aGy+uYNUgpZzYEmZ+v0zeI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=iLT2nV3RcJK+XNuTM9eT5iDvkKI9jEqydd/LsRnUS5jysKoZFYa7CDDUtCo4aOvpga D57au92oNtsN3Efs+LjpLY3znfG9CBPuFx0M6Fpd1ep3F1wjT7MCq4SarrG95xGQezg4 HD2GJUdIpxkDal5PGY0Xcu9j0LU9/G9WI7W4s= Received: by 10.141.99.2 with SMTP id b2mr1516823rvm.46.1230783742473; Wed, 31 Dec 2008 20:22:22 -0800 (PST) Received: by 10.140.144.11 with HTTP; Wed, 31 Dec 2008 20:22:22 -0800 (PST) Message-ID: <340a29540812312022k5ab62972j9a11c0edf25b7448@mail.gmail.com> Date: Wed, 31 Dec 2008 21:22:22 -0700 From: "Andrew Falanga" To: "Free BSD Questions list" In-Reply-To: <20090101004217.GA32222@teddy.fas.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20090101004217.GA32222@teddy.fas.com> 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 04:22:23 -0000 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. Hope this is of help to you. Andy -- A: Because it messes up the order in which people normally read text. Q: Why is it such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet and in e-mail?