postgresql network access problem

[Andrew Falanga]

On Wed, Dec 31, 2008 at 5:42 PM, stan <stanb at 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?