Re: [HACKERS] Better detection of staled postmaster.pid

2015-08-31 Thread Tom Lane
Kevin Grittner writes: > Pavel Raiskup wrote: >> It's been reported [1] that postmaster fails to start against staled >> postmaster.pid after (e.g.) power outage on Fedora, > Was the other newly started process another PostgreSQL cluster? > Was it launched under the same OS user? Yes, that's wh

Re: [HACKERS] Better detection of staled postmaster.pid

2015-08-31 Thread David G. Johnston
On Mon, Aug 31, 2015 at 10:20 AM, Kevin Grittner wrote: > Pavel Raiskup wrote: > > > It's been reported [1] that postmaster fails to start against staled > > postmaster.pid after (e.g.) power outage on Fedora, its due to init > system > > parallelism and "some" other newly started process can al

Re: [HACKERS] Better detection of staled postmaster.pid

2015-08-31 Thread Kevin Grittner
Pavel Raiskup wrote: > It's been reported [1] that postmaster fails to start against staled > postmaster.pid after (e.g.) power outage on Fedora, its due to init system > parallelism and "some" other newly started process can already have allocated > the same PID as the old postmaster had -- and

[HACKERS] Better detection of staled postmaster.pid

2015-08-31 Thread Pavel Raiskup
This is most likely just a request for brainstorm. It's been reported [1] that postmaster fails to start against staled postmaster.pid after (e.g.) power outage on Fedora, its due to init system parallelism and "some" other newly started process can already have allocated the same PID as the old p