Re: [ADMIN] pgsql.sh

On Mon, 23 Nov 1998, Jonah Kuo wrote:

> Hello,
>
> 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.

On this line:

-S -o -F > /usr/local/pgsql/errlog' &

Modify it to look like this:

-S -o -F 2>&1 > /usr/local/pgsql/errlog' &

Assuming this script runs through bash it will direct standard error
(stderr) to standard output (stdout). All output will be sent to
/usr/local/pgsql/errlog.

Enjoy.
-M@

--
Matthew Hixson - CIO Linux, n;
FroZenWave Communications the nouveau postmodern operating
http://www.frozenwave.com system for the masses