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

2017-06-23 Thread Daniel Verite
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 /path/to/

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

2017-06-23 Thread Muhammad Hanif Abdul Hamid
experienced this problem. Thank you. -Original Message- From: Michael Paquier [mailto:michael.paqu...@gmail.com] Sent: Jumaat, 23 Jun 2017 1:26 ptg To: Tom Lane Cc: Muhammad Hanif Abdul Hamid ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Suddenly - LOG: could not open file

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

2017-06-22 Thread Michael Paquier
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 your second statement is false. *Something* >

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

2017-06-22 Thread Tom Lane
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 the postmaster.

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

2017-06-22 Thread Muhammad Hanif Abdul Hamid
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 s