Re: How to wait until startup completes

Gary Horton <Gary(dot)Horton(at)Sun(dot)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