Re: [ADMIN] pgsql.sh

On Tue, 24 Nov 1998, Jonah Kuo wrote:

> > -S -o -F 2>&1 > /usr/local/pgsql/errlog' &
>
> It still doesn't help,  I have bash installed in /usr/local/bin, then
> I modified the first line to #!/usr/local/bin/bash, amd modified
> the line you wrote above, then try again, then result in same.
>
> I simply test it to see if it works as do the following, login as postgres
> and enter interactive monitor,
>
> postgres=> ls;
> ERROR:  parser: parse error at or near "ls"
>
> The same ERROR message appears on the console, and errlog size is
> still 0.

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@

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