Re: Database server crash ! URGENT ! - Mailing list pgsql-general

From Tom Lane
Subject Re: Database server crash ! URGENT !
Date
Msg-id 24821.1005897452@sss.pgh.pa.us
Whole thread Raw
In response to Re: Database server crash ! URGENT !  ("Sunit Bhatia" <sunit_bhatia@hotmail.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Sunit Bhatia"
Date:
Subject: Re: Database server crash ! URGENT !
Next
From: Tom Lane
Date:
Subject: Re: Compiling v7.1.3 w/OpenSSL and Krb5 support...