Re: Database server crash ! URGENT !

I've narrowed down the problem. Here is what I did:

As suggested by everybody, I started the server like this:

su - pgsql -c "nohup $DB_ROOT/bin/postmaster -B 50 -N 25 -D$DB_ROOT/data
-i" </dev/null >>$LOGFILE 2>&1 </dev/null &

After this the process is started on the background. Now If I type
'Control-C' on the terminal, it generates 'Fast Shutdown' request to the
Server Process, and server is shutdown.

This happens if the database user 'pgsql' is created with BOURNE SHELL as
default.

I tried the same on other system, where the 'pgsql' user was created with
tcsh shell as default, and it DOES NOT send the Fast Shutdown request to the
server on typing 'Control-C' on the terminal.

Can anybody tell me how I can avoid this from happening in the Bourne Shell
?? Detaching the 'stdin' from the terminal doesn't seem to be helping here
!!

thanks
Sunit

>"Sunit Bhatia" <sunit_bhatia(at)hotmail(dot)com> writes:
>
> > Let me make some corrections to my previous mail.
> > I start the PostgreSQL Server as 'root' like this:
> >
> > su - pgsql -c "$DB_ROOT/bin/postmaster -B 50 -N 25 -D$DB_ROOT/data -i"
> >>
> > $LOGFILE 2>&1 &
> >
> >
> > So I'm staring it in the background and I'm redirecting the stdout
> > and stderr away from the terminal. Still I don't understand why it
> > receives Fast Shutdown Request or (SIGINT signal).
>
>You might need to also run it with 'nohup'.
>
>-Doug
>--
>Let us cross over the river, and rest under the shade of the trees.
> --T. J. Jackson, 1863
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp