Fixed it... had to set the tcpip_socket = true in postgresql.conf.
Doug Gorley | [EMAIL PROTECTED]
----- Original Message -----
From: [EMAIL PROTECTED]
Date: Monday, March 10, 2003 12:24 pm
Subject: [gentoo-user] Starting PostgreSQL with -i from init.d script
> Hello again list,
>
> I got PostgreSQL starting nicely from the init.d script with some
> help, but I've hit another stumbling block. I'd like the
> postmaster to run with the '-i' option (allow TCP connections)
> when started from the init script. The script's start function
> looks like this:
>
> start() {
> ebegin "Starting postgres"
> su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l
> '$PGLOG' -o '$PGOPTS'"
> eend $?
> }
>
> I'm trying to figure out where I can set $PGOPTS to '-i' su that
> it will be recognized in the script. I've tried:
>
> (a) export PGOPTS='-i' before running the init script
> (b) Creating /etc/env.d/10postgresql to set PGOPTS, env-update,
> source /etc/profile
> (c) Setting /var/lib/postgresql/data/postmaster.opts to include '-
> i' (though I think this gets set from the options postmaster was
> started with, not the other way around.)
>
> None of these seem to work. In fact, I can't find where any of
> the $PG... options are set! I could probably hard-code this into
> the init script, but there has to be a better way. Does anyone
> know what do do here?
>
> Thanks again,
>
> Doug Gorley | [EMAIL PROTECTED]
>
>
>
> --
> [EMAIL PROTECTED] mailing list
>
>
--
[EMAIL PROTECTED] mailing list
