Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

Muhammad Hanif Abdul Hamid wrote: > Maybe an irrelevant question, but I would like to know if there anything > from postgres process (e.g any parameter that is not set right) that might > remove the postmaster.pid? If using Linux, you may put it under watch with # auditctl -w

Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

Hi, Thanks for your reply, Tom and Michael. Maybe an irrelevant question, but I would like to know if there anything from postgres process (e.g any parameter that is not set right) that might remove the postmaster.pid? FYI, we have 20 other sites with the same database use but have not

Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

On Fri, Jun 23, 2017 at 1:43 PM, Tom Lane wrote: > Muhammad Hanif Abdul Hamid writes: >> Within this week, I have faced two times "postmaster.pid" went missing in a >> sudden. Nobody deleted it or shutdown the server. > > I'd lay very long odds that

Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

Muhammad Hanif Abdul Hamid writes: > Within this week, I have faced two times "postmaster.pid" went missing in a > sudden. Nobody deleted it or shutdown the server. I'd lay very long odds that your second statement is false. *Something* removed that file, and it wasn't

[GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

Hi, Within this week, I have faced two times "postmaster.pid" went missing in a sudden. Nobody deleted it or shutdown the server. May I know anybody who has ever experience this? Can please anybody can help me on this? 2017-06-20 13:10:10.261 MYT [24726] [unknown]@[unknown] LOG: incomplete