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
