Date: Wed, 31 Dec 2008 21:22:22 -0700 From: "Andrew Falanga" <af300wsm@gmail.com> To: "Free BSD Questions list" <freebsd-questions@freebsd.org> Subject: Re: postgresql network access problem Message-ID: <340a29540812312022k5ab62972j9a11c0edf25b7448@mail.gmail.com> In-Reply-To: <20090101004217.GA32222@teddy.fas.com> References: <20090101004217.GA32222@teddy.fas.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, Dec 31, 2008 at 5:42 PM, stan <stanb@panix.com> 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?
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?340a29540812312022k5ab62972j9a11c0edf25b7448>