"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