In my application, I do the following before saying "ok db is up"
1- Look for the PID, that tells me postmaster at least is a process and
has an ID
2- Check /proc/pid
3- Connect to template-1
4- Connect to MyDatabase
5- Query something,
That tells me that all parts are working....
By the way, does the '-w' on start gives up in 60 seconds or
indefinitely blocks...
Tom Lane wrote:
>Sean Chittenden <sean@chittenden.org> writes:
>
>
>>I personally find the behavior of pg_ctl connecting to the postmaster
>>_after_ it's started up to verify that it has indeed started up, to be
>>a rather broken behavior and think that it shouldn't be the default.
>>
>>
>
>?? It isn't.
>
>I agree that we could do with a better mechanism, though.
>
> regards, tom lane
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>