Re: Database server crash ! URGENT !

"Sunit Bhatia" <sunit_bhatia(at)hotmail(dot)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