Re: [HACKERS] postgres under linux can't start because of postmaster.pid

2007-10-25 Thread Tom Lane
"Richard Wang" <[EMAIL PROTECTED]> writes: > I just consider this may happens and pg can't recover correctly: > if postgres crashed last time and left a postmaster.pid file, and last > postgres > id is reused by another process which is not postgres now. Postgres defends itself against that just

Re: [HACKERS] postgres under linux can't start because of postmaster.pid

2007-10-25 Thread Richard Wang
I just consider this may happens and pg can't recover correctly: if postgres crashed last time and left a postmaster.pid file, and last postgres id is reused by another process which is not postgres now. "Tom Lane" <[EMAIL PROTECTED]> дÈëÏûÏ¢ÐÂÎÅ:[EMAIL PROTECTED] > "Richard Wang" <[EMAIL PROTE

Re: [HACKERS] postgres under linux can't start because of postmaster.pid

2007-10-24 Thread Tom Lane
"Richard Wang" <[EMAIL PROTECTED]> writes: > I construct a postmaster.pid file and then set the pid to be one of existing > process id(not postgres, e.g vim), then I run postgres. This may happen if > postgres crashed last time and left a postmaster.pid file, and last postgres > id is reused by