On Wed, Dec 31, 2008 at 09:22:22PM -0700, Andrew Falanga wrote: > On Wed, Dec 31, 2008 at 5:42 PM, stan <[email protected]> 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. _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[email protected]"
