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