Re: Unreliable "pg_ctl -w start" again - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Unreliable "pg_ctl -w start" again
Date
Msg-id 270.1327719086@sss.pgh.pa.us
Whole thread Raw
In response to Re: Unreliable "pg_ctl -w start" again  ("MauMau" <maumau307@gmail.com>)
Responses Re: Unreliable "pg_ctl -w start" again  ("MauMau" <maumau307@gmail.com>)
List pgsql-hackers
"MauMau" <maumau307@gmail.com> writes:
> From: "Tom Lane" <tgl@sss.pgh.pa.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Confusing EXPLAIN output in case of inherited tables
Next
From: Tom Lane
Date:
Subject: Re: Temp file missing during large pgbench data set