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 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 another process which is not postgres now. > > Don't do that. The postmaster is perfectly capable of recovering on > its own, why would you want to mess with the postmaster.pid file? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
