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.

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
freebsd-questions@freebsd.org mailing list
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"

Reply via email to