Re: [PATCH] pg_isready (was: [WIP] pg_ping utility)

On Sat, Jan 26, 2013 at 11:53 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 2013/1/26 Phil Sorber <phil@omniti.com>:
>> On Sat, Jan 26, 2013 at 4:02 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>>> Hello
>>>
>>> We now haw to solve small puppet issue, because our puppets try to
>>> start server too early, when old instance live still.
>>>
>>> Maybe some new parameter - is_done can be useful.
>>>
>>
>> What about something like:
>> pg_isready; while [ $? -ne 2 ]; do sleep 1; pg_isready; done
>
> it is not enough - server is done in a moment, where can be started
> again - or when we can do safe copy of database data directory.
>

I guess i am not completely understanding the case you are trying to
solve. Can you explain a bit further?

> Regards
>
> Pavel
>
>
>
>>
>> Perhaps with a counter to break out of the loop after some number of attempts.
>>
>>> Regards
>>>
>>> Pavel
>>>