I got the answer!! -- Re: [ADMIN] pgsql.sh

Matthew Hixson wrote:

> I think this might be part of the problem: from 'man postmaster'
>
> " -S Specifies that the postmaster process should start up in silent mode.
> That is, it will
> disassociate from the user's (controlling) tty and start its
> own process group. This
> should not be used in combination with debugging options
> because any messages printed
> to standard output and standard error are discarded."
>
> Another problem could be that the -o option means that the rest of the
> line should be sent to the backend as commandline arguments, so it might
> not be grabbing the ouput from postmaster at all.
> Here's my startup script:
>
> echo "postmaster -B 256 >/home/postgres/pm.log 2>&1 &" | su - postgres
>
> This is on my Slackware system.
>
> -M@
>

Here is my new pgsql.sh, you can see the differences between the new one and
oringinal one.

#!/bin/sh
[ -x /tmp/.s.PGSQL.* ] && rm -f /tmp/.s.PGSQL.*
[ -x /usr/local/pgsql/bin/postmaster ] && \
su -l postgres -c 'exec \
/usr/local/pgsql/bin/postmaster \
-D/usr/local/pgsql/data \
-o -F > /usr/local/pgsql/errlog 2>&1' & \
echo -n ' pgSQL' &

Thanks all folks who gave me the light.

Jonah