Re: Unreliable "pg_ctl -w start" again

"MauMau" <maumau307(at)gmail(dot)com> writes:
> From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>> Looks like complete nonsense to me, if the goal is to behave sanely when
>> postmaster.pid hasn't been created yet. Where do you think get_pgpid
>> gets the PID from?

> Yes, I understand that get_pgpid() gets the pid from postmaster.pid, which
> may be the pid of the previous postmaster that did not stop cleanly.
> [ convoluted reasoning about what to do if that's the case ]

I don't see any point in worrying about that case when you can't handle
the basic case that the postmaster hasn't created postmaster.pid yet.
In any case, this does nothing at all to answer the question you posed,
which was how long is it reasonable to wait for the postmaster to
produce a new postmaster.pid file. We really need to know the PID of
the process we started in order to make any real improvement here.

regards, tom lane