Re: How to wait until startup completes - Mailing list pgsql-general

From Tom Lane
Subject Re: How to wait until startup completes
Date
Msg-id 16876.1117646023@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to wait until startup completes  (Gary Horton <Gary.Horton@Sun.COM>)
Responses Re: How to wait until startup completes
List pgsql-general
Gary Horton <Gary.Horton@Sun.COM> writes:
> Tom Lane wrote:
>> The -w-doesn't-wait-long-enough bit needs investigation.

> No messages, no smoking gun. If you mean running the sh script with -x,
> it's really not complicated enough to warrant that - I've added echo
> statements to confirm that it's just falling through. But let's be sure
> we're saying the same thing: I would expect pg_ctl -w to /block/ until
> database is started, in other words by the time the pg_ctl command
> "returns", then checking database status with psql -l should
> succeed...are we on the same page?

Yeah ... in fact, if you read the script, what it does is loop until a
psql -l succeeds ... so why wouldn't your following instance also
succeed?

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Old problem needs solution
Next
From: Richard Huxton
Date:
Subject: Re: Can I catch sentences in SQL using triggers?