Re: [Phpwiki-talk] WikiFatalError

[Jeff D. <da...@da...>]

Tim Bogart said:
> Ah Hah!  My db server is not set up properly.  In short the postmaster
> is not  running with the -i option.  I tried to edit the
> /var/init.d/postgres file to  include it but the service fails to
> restart no matter where I try to put the  thing.

I the db server running on a different host than the HTTP server?
If not, there may be a way to avoid the -i.  (Using -i may have
security implications...)


> The whole line looks like this...
>
>         su -l postgres -s /bin/sh -c
> "/usr/bin/pg_ctl  -D  $PGDATA -p /usr/bin/postmaster start  > /dev/null
> 2>&1" < /dev/null

Here, you are running pg_ctl which in turn runs postmaster.  (Actually, your
are running su, which in turn runs /bin/sh which in turn runs pg_ctl, which
finally runs postmaster...)

In any case, to get pg_ctl to pass options to postmaster you need to use the
-o option (to pg_ctl).  So something like:

   su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl  -D  $PGDATA -o '-i' -p
/usr/bin/postmaster start  > /dev/null 2>&1" < /dev/null

might work.  (It's just a guess though.)