Re: How to wait until startup completes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to wait until startup completes
Дата
Msg-id 16876.1117646023@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to wait until startup completes  (Gary Horton <Gary.Horton@Sun.COM>)
Ответы Re: How to wait until startup completes
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Old problem needs solution
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Can I catch sentences in SQL using triggers?