Thanks for your information. I couldn't find the "ulimit" setting in postgresql.conf. Where can I find it? I use the default settings in pgsql.
Thanks. Roger Lam ----- Original Message ----- From: "Tom Lane" <[EMAIL PROTECTED]> To: "roger" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, October 10, 2004 3:29 PM Subject: Re: [ADMIN] Postmaster terminated without any error message > "roger" <[EMAIL PROTECTED]> writes: > > We have Postgresql 7.2 under Redhat 7.2. Postmaster can be started and we c= > > an use it without problem. However postmaster will terminate abnormally aft= > > er 1 or 2 hours and leave no error messages. > > I suspect you are starting the postmaster under resource constraints > (check "ulimit" settings) or else the postmaster is getting hit by the > kernel's infamous "out-of-memory killer" (google for "OOM kill" for more > info). > > In recent Linux kernels you can prevent OOM kills by adjusting the > kernel's memory allocation parameters, but RH 7.2 may be too old to give > you that control. > > regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
