Re: Database server crash ! URGENT !

"Sunit Bhatia" <sunit_bhatia@hotmail.com> writes:
> 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 &

Not sure, but maybe the correct spelling is

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

As is, you're redirecting the stdin etc of su, not of the
eventually-launched shell that execs the postmaster.  I don't know if
that's the problem, but it seems unlikely to be a good idea.

            regards, tom lane