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

Reply via email to