Re: [ADMIN] pgsql.sh

On Mon, 23 Nov 1998, Jonah Kuo wrote:
>Hello,

Hey!

>First of all, I apologize if this has been discussed before.
>
>I have this startup script 'pgsql.sh' on my FreeBSD-3.0 system,
>everything goes fine except I can't have error messages send to
>the file I specified in this script
>
>#!/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
> -S -o -F > /usr/local/pgsql/errlog' &
> echo -n ' pgSQL'
>}
>
>There was an /usr/local/pgsql/errlog opened, and the error messages are
>always
>send to console regardless of specifying '-S' option or not.
>
>Is there anybody encountered this before? any help would be grateful.

Just an offhand guess, but maybe you need to also redirect STERR in addition to
STOUT to /usr/local/pgsql/errlog? Shell scripts have never been my thing, but
isn't it something like "... > /usr/local/pgsql/errlog 2>&1 &" or something
along those lines perhaps? (No since giving misinformation; I just double
checked my own init.d script and it is, in fact, correctly stated above. Well,
after I fixed my mistake... *grin*.)

>Jonah
--

Sincerely,
Jason Boxman

uselinux(at)email(dot)com
benefits(at)cybertechs(dot)com

"We have lived not in proportion to the number of years we have
spent on the earth, but in proportion as we have enjoyed."
-Henry David Thoreau